topic Re: Ole2_Object - Free Object excel doesn't terminate excel process in Application Development and Automation Discussions

Ole2_Object - Free Object excel doesn't terminate excel process

Former Member — Fri, 30 Oct 2009 11:02:53 GMT

Hi experts,

I have developed a program that creates an excel file in my pc. I'm using de FREE OBJECT for all ole2_object's that i use and the file is being created properly. However, when i check the existing processes in my task manager there is an EXCEL process refering to the file created by my program.

Can anyone help to find a way to terminate this process from my program?

Here's a part of my program were i save my file and clear the created objects:

...

CALL METHOD OF workbook 'SaveAs'

EXPORTING

#1 = v_filepath.

CALL METHOD OF workbook 'Close'.

CALL METHOD OF excel_object 'Quit'.

FREE OBJECT: excel_object, workbook_list, application,

sheet, workbook, border.

Thanks for your help in advanced.

Diana Pinto

Re: Ole2_Object - Free Object excel doesn't terminate excel process

Former Member — Mon, 02 Nov 2009 09:22:40 GMT

Hi,

Try using CL_GUI_CFW=>flush.

Regards,

Vasanth

Re: Ole2_Object - Free Object excel doesn't terminate excel process

Former Member — Mon, 02 Nov 2009 10:34:45 GMT

Hi Vasanth,

Thanks for your answer, however it didn't help me.

I tried using the cl_gui_cfw=>flush after the creation of my excel file but the process still stand's pending on my pc and the method doesn't return any error code.

Regards,

Diana Pinto