Excel process remains in task manager

  • Thread starter Thread starter fran
  • Start date Start date
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.
 
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
 
-----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?
 
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
 
Back
Top