Excel process remains in task manager

F

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.
 
M

MDW

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
 
G

Guest

-----Original Message-----
Ensure that when you're completely done w. Excel, you
Click to expand...
close the workbook and the Excel App AND set them both to
nothing.
objWorkbook.Close
Set objWorkbook = Nothing

objXL.Quit
Set objXL = Nothing
.
Click to expand...
The excel object is closed and quit. The object is also
set to nothing. Any other ideas?
 
P

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
 
Top