Skip to Content
author's profile photo Former Member
0
Former Member

Excel and ABAP: protect sheet

Posted on Jun 18, 2004 at 10:06 AM 319 Views

The method 'Protect' from the spreadsheet interface will protect the worksheet in Excel with a password. However, password is not one of the parameters of the method, hence SAP provides a "secret" password somewhere.

This would mean I would have to use the method 'Protect' again to unprotect the worksheet. However I would like to be able to change the worksheet using Excel.

Does anyone knows this password or is there another way to provide the password for protecting the worksheet?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Marc Bernard
    Marc Bernard
    Posted on Jun 18, 2004 at 03:33 PM
    0

    Hello John,

    the protect method locks only the cells that have the "locked" property turned on. Since this is the default the complete sheet will be locked unless you turn off this property first. For that reason you have the protect_range method. Use it to unlock the cells that you want to work with in Excel. Then call the protect method.

    Regards,

    Marc

    SAP NetWeaver RIG, US BI

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 21, 2004 at 07:27 AM

      Thanks for your quick answer Marc. However, this still doesn't solve my problem.

      I would like to create an Excel sheet using ABAP (and protect some ranges in the sheet). The sheet will be sent to suppliers to fill in some data and will be returned. Then I would like to process the sheet just using Excel and for that reason I would like to be able to unprotect the sheet. To unprotect the range/sheet I have to supply a password... Since "password" is not an parameter of either the method Protect/Protect_range this password is supplied somewhere else.

      Kind regards,

      John.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 21, 2004 at 07:38 AM
    0

    Hello John,

    I have solved a similar problem. But i have used an other approach.

    1.) Fetch the Data from SAP via VBA and RFC from Excel

    2.) Afterwards you can send the Excel (with protected ranges) to your partner using build in functionality.

    3.) If you get back the sheet you can send the result to SAP (using f.x. inplace EXCEL).

    This solution is a little bit tricky but works fine.

    If you want, i can sent you some sample coding.

    BR

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2004 at 09:10 PM
    0

    There is a alternate method (using OLE) that fits your requirement.

    Download the file contents to NT / Local drive... Apply OLE to the data file (Use EXCEL Macro to record the Excel sheet actions (like BDC Recording) and you have to implement all the method statments recorded by EXCEL Macro recording in ABAP..With this, You can set your own password (Static or Dynamically determined by program logic)

    Ig you have any further Q's , Send me a mail..I will send you a sample code..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.