OLE: Excel.Application

[myname]

Hello,

in VB.Net, I use Excel to display results :

dim xl as new Excel.Application // creates an Excel process
// snip (putting values into cells)
xl.Visible = true

If the user closes the Excel file and then my program,
the Excel process is killed in memory, which is good.

If the user closes my program first and then the Excel file,
the Excel process remains in memory !

How can I make sure the process will be killed ?

Thanks !

 

[Harald Staff]

Hi

You need to set
xl.quit
(and before that ensure that excel doesn't halt and ask things like "save
changes?" on quitting) somewhere in your program, in the unload event of
your main form or something.

HTH. best wishes Harald

 

[dbahooker]

I have used KILL.exe in order to deal with this before.

-Aaron