topic Upload excel using OLE objects in Application Development and Automation Discussions

Upload excel using OLE objects

former_member192842 — Tue, 29 Sep 2015 04:56:58 GMT

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

Re: Upload excel using OLE objects

RaymondGiuseppi — Tue, 29 Sep 2015 06:25:45 GMT

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