Excel process remains in task manager

[fran]

I am running an app in Access97 that modifies an Excel
spreadsheet. When the app saves and closes the Excel app,
the process remains in the task manager.

Any ideas would be appreciated.

 

[Guest]

Ensure that when you're completely done w. Excel, you close the workbook and the Excel App AND set them both to nothing

objWorkbook.Clos
Set objWorkbook = Nothin

objXL.Qui
Set objXL = Nothing

 

[Guest]

-----Original Message-----
Ensure that when you're completely done w. Excel, you

close the workbook and the Excel App AND set them both to
nothing.

objWorkbook.Close
Set objWorkbook = Nothing

objXL.Quit
Set objXL = Nothing
.

The excel object is closed and quit. The object is also
set to nothing. Any other ideas?

 

[Perry]

Maybe below article will be helpfull
http://tushar-mehta.com/index.html?http://tushar-mehta.com/excel/vba/xl_doesnt_quit/

There was another issue on an Excel bug.
Can't recollect the KB article in which MS published this bug (and the
workaround)
Try to look it up in KB, using keywords
Excel Doesn't Quit

The workaround as published in above mentioned (phantom) KB article
avoid
With wbk.Sheets(1)
.Cells(1, 1) = 12
End with
instead use
wbk.Sheets(1).Cells(1, 1) = 12

Krgrds,
Perry