topic Re: Close OLE processes in Application Development and Automation Discussions

Close OLE processes

marcelom_bovo — Fri, 27 Feb 2009 18:16:59 GMT

Hi people,

I´m using OLE objects to manipulate Excel, but I´m having one problem,

Once I stop using the spreadsheet I use the method "QUIT" and then "FREE OBJECT" to kill the excel processes, BUT, the processes do not close.

After I used the program a few times, I look at the task manager and its full of excel processes.

I tried to use the "FREE OBJECT" in all OLE objects and in the application only, but none of this work out.

Someone can help me with that?

Thanks

Re: Close OLE processes

RichHeilman — Fri, 27 Feb 2009 19:43:35 GMT

There may be something in your ABAP code in between when you open the file and when you close that file that is not right and hence causing a disconnect. If there is a disconnect, this is the reason why your excel program is left open. YOu need to make sure that every method that you are calling in between the open and close is being called correctly, and is sucessful. If one method call fails, it could cause a disconnect. I have seen this in the past.

Regards,

Rich Heilman

Re: Close OLE processes

RaymondGiuseppi — Fri, 27 Feb 2009 20:18:52 GMT

Are you using steps like

CREATE OBJECT e_appl 'EXCEL.APPLICATION'.
SET PROPERTY OF e_appl 'VISIBLE' = 1.
CALL METHOD OF e_appl 'WORKBOOKS' = e_work.
CALL METHOD OF e_work 'Add' = e_work.
GET PROPERTY OF e_appl 'ActiveSheet' = e_activesheet.
SET PROPERTY OF e_activesheet 'Name' = <sheetname>.

" work witch cells

CALL METHOD OF e_work 'SAVEAS' EXPORTING #1 = <filename>.
CALL METHOD OF e_work 'close'. " maybe this one is missing
CALL METHOD OF e_appl 'QUIT'.
FREE OBJECT e_appl.

Regards