EXCEL still open !

[fabio_prando]

Hi Everyone !

I developed a report using MS-EXCEL with COM-HANDLE.

My .p has a bug, because when it´s finished, excel is still open in memory.

I used de method CLOSE() for the workbooks, and RELEASE OBJECTS for all variables COM-HANDLE that I use in the program.

I´ve made some tests and realised that it only doesn´t work when the program execute the function COPY() of sheet object.

I´d like know what I must do to close the EXCEL !!

I bet in yours expiriences to help !!!

See You !

Fábio Prando

 

[NickA]

Have you called the quit() method? (Against the application object).

 

[fabio_prando]

:chat:

Hi !

I´ve tryed that too ! but it didn´t work !!

By the way, thanks for your help !!!


Regards,

Fábio Prando

 

[Kenneth Chow]

Maybe try CLOSE(0).

 

[Jupiter]

Hi Guys I think I have a solution for the nagging "Excel Still Open" Problem.
This thread is 6 years old. I hope many of us have the solution by now. :awink:

Still...

The following code should do the trick. They must be written in given order.

chExcelApplication:Activewindow:CLOSE().
chExcelApplication:QUIT().
Release Object chExcelApplication.

Please give the user enough opportunity to save the file before closing it.

If we release the comhandle first and wait for the user to close the file, Excel is going to run in the background for ever because the background excel.exe is the parent of the still-opened excel file. On closing the child the OS has no clue that it should close the parent also.

 

[joey.jeremiah]

this will happen if you haven't released every com-handle.

take a look at this thread from PEG -

http://www.peg.com/lists/api/history/200507/msg00008.html

hope this helps.