OLE Objects

[Former Member]

Hello everyone,

I'm trying to upload the excel and process it using OLE objects, after my transaction completes, when i try to open the excel it gives warning message as file is already open, even after i have used FREE OBJECT method for excel application at end of code. After i open the file i can edit it and save back, but when i re run the same transaction and try to open, it says excel is locked for editing !! Please help me on this, Or Inform any way to open the excel in read only mode.

Regards,

Shankar.

[bastinvinoth]

Hi Shankar Kulkarni

I think while executing the transaction, excel file is opened by code that's why it shows warning message.

Add this code at last and try with it.

 CALL METHOD OF
      H_EXCEL
      'QUIT'.
  FREE OBJECT H_EXCEL.
  H_EXCEL-HANDLE = -1.
FREE OBJECT H_EXCEL.

[Former Member]

Hi Bastin,

It did not work . Can u please tell me the way to open the excel in read mode. So that it wont even lock.

Regards,

Shankar

[bastinvinoth]

Hi Shankar Kulkarni,

I have not tried with read mode option  

Check this threads  Clemens reply maybe helpful for you.

Amit mittal answer