Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Upload excel using OLE objects

Go to solution
former_member192842
Participant

‎2015 Sep 29 5:56 AM

0 Likes
705

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

1 ACCEPTED SOLUTION
Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2015 Sep 29 7:25 AM

0 Likes
454

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

1 REPLY 1
Read only

Go to solution
RaymondGiuseppi
Active Contributor

‎2015 Sep 29 7:25 AM

0 Likes
455

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