How to open and close excel with our leaving ghost file

  • Thread starter Thread starter moondaddy
  • Start date Start date
M

moondaddy

I'm writing an app in access 2003 and need to open and close excel files.
however, when the excel file is closed, it leaves a ghost file in memory
which causes periodic problems with opening and saving other excel files.
I'm sure this is a common problem. Is there a proper way to handle this?

Thanks
 
to rid of ghost - follow these rules:
- clear all references to excel object after you close/stop using them
- close opened file, and clear reference to it
- quit excel and clear reference

close - means set object to nothing
HTH
 
Back
Top