Closing an excel application

[Silgd1]

Hi All....

I'm using python 2.4, Win XP Pro v.2002 sp3, and I use pyscripter 1.9.9.2 as my editor.

I have written code to open an existing excel file and grab some data. The problem I am having is closing down the excel application. Here some "bits" of the code I am using:

xlApp = Dispatch("Excel.Application")
 
xlApp.Workbooks.Open(Filename = path+fname)

I am closing the workbook by doing the following:

xlApp.Workbooks.Close()

I am trying to quit the excel application by doing the following:

xlApp.quit()

The problem is when I check the windows Task Manager, the EXCEL.EXE is still present. From all I have read, this is the correct way to close the workbook and exit the excel application.

Can anyone tell me what I might be doing wrong.

Thanks in advance.

Silgd1

[Silgd1]

I found out that you must do the following:

xlApp.Visible = 0
del xlApp

you must make x1App.Visible=0 before you use del x1App, otherwise EXCEL.EXE remains in memory.

[bvdet]

Thanks for updating us with the solution. I am only somewhat familiar with win32com. I usually interface with Excel using CSV files.

-BV