Closing Excel in Delphi 5

[MARTINRODDY]

Hi,

I have created an instance of an excel worksheet in a system I'm developing. The data is read from the spreadhseet and everything works fine. The problem I have is that the instance of excel stays open in memory when I close the software. The process list from alt+ctrl+del shows that EXCEL.EXE still lives. I have included openexcel.quit; in my code but doesn't seem to work. This causes Excel to freeze if you try and open it through the start menu etc.

Does anyone have a statement which will kill this EXCEL.EXE process, it causes the memory to clog if the functionality is run often.

Appreciated.
Martin

 

[DelphiAaron]

i also have this problem when opening a spreadsheet from a web page..

what version of excel and windows are you running ?

 

[hiennha]

var ExcelApp: OleVariant;
....
Before you close your application, put this code:
if not VarIsEmpty(ExcelApp) then
ExcelApp.Quit;
Close; //Close your main form
Nha