Upload excel using OLE objects

[former_member192842]

Hi Experts,

I'm reading an excel file from desktop using OLE objects.

But after executing the program, Now I opened the excel file in desktop, Im getting a popup that the file is locked by me. I'm getting this error whenever I use OLE objects to read the file.

How to avoid this error.

Please advise

Regards

Anand

[former_member192842]

Hi Experts,

I'm reading an excel file from desktop using OLE objects.

But after executing the program, Now I opened the excel file in desktop, Im getting a popup that the file is locked by me. I'm getting this error whenever I use OLE objects to read the file.

How to avoid this error.

Please advise

Regards

Anand

[RaymondGiuseppi]

Did you execute

• CALL METHOD OF application 'QUIT'. " Also methods SAVE and QUIT of dependent objects can be required : cell, range, worksheet, workbook
• FREE every object
• CALL METHOD CL_GUI_CFW=>flush.

If that doesn't solve problem, use search tool there are already "some" threads/discussions (and some OSS notes on OLE limitation from Abap) on this subject.

Regards,

Raymond