Problem with OLE in ECC 6.0 Upgraded system

[Former Member]

Hi,

I'm using OLE2 objects to Protect the Excel sheet. It worked well in SAP 4.7 but it is not working in ECC 6

My requirement is like i need to make few columns editable and the sheet needs to be protected

The problem is the objects are not initialized Properly. Even then the formatting options and sheet protection and all working fine.

But the AllowEditRanges method is not working.

I'm attaching my code here

      GET PROPERTY OF h_sheet 'Protection' = h_protect.
      GET PROPERTY OF h_protect 'AllowEditRanges' = h_selrange.
      CALL METHOD OF h_sheet 'RANGE' = h_edrange
        EXPORTING
        #1 = c_k11
        #2 = l_cell.
 
      CALL METHOD OF h_selrange 'Add'
        EXPORTING
        #1 = 'Range1'
        #2 = h_edrange.

Is that problem with the code are any specific settings are required in upgraded system

[Former Member]

HI,

Try using the Capital letters for the values in quotes

regards

Pavan

[Former Member]

Hi,

thanks for the reply. I tried in that also. But it is not working....

Do we have any other methods to achieve this

[Former Member]

Solved