topic Re: OLE Objects in Application Development and Automation Discussions

OLE Objects

Former Member — Mon, 28 Oct 2013 07:16:00 GMT

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.

Re: OLE Objects

bastinvinoth — Mon, 28 Oct 2013 07:25:10 GMT

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.

Re: OLE Objects

Former Member — Mon, 28 Oct 2013 08:42:02 GMT

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

Re: OLE Objects

bastinvinoth — Mon, 28 Oct 2013 08:59:28 GMT

Hi Shankar Kulkarni,

I have not tried with read mode option

Check this threads Clemens reply maybe helpful for you.

Amit mittal answer