Closing excel with lotusscript

HCL Domino Domino Forum
1

hello

I make an excel file starting with:

Set obj = CreateObject(“Excel.Application”)

Call obj.Workbooks.Add

ending/closing with:

obj.ActiveWorkbook.SaveAs( FileName$ )

obj.WorkBooks.Close

obj.Quit

Set obj = Nothing

But EXCEL.EXE always stays existed as a proccess if im looking at the windows taskmanager.

How can i close this?

2

Subject: Excel 2003?

If you check other excel forums you’ll see that it seems to be a common problem with excel 2003. Do you also use that version?Until now I didn’t find an appropriate solution, because I don’t want to close ALL excel processes (if a user is working in excel beside)… So I’ve to live with it.

But any solutions are welcome :slight_smile:

3

Subject: excel 2003

yes im using excel 2003 :(but anyway they use excel 98 at work so the problem will not appear I guess :slight_smile:

thanks

4

Subject: Looks okay to me

The only time I’ve seen that happen is if there was an error, and the Quit statement was not executed.

Ensure that you have error-checking code activated, and that the close-out statements will always be run, and it should always fully close the program.