How to open and close excel with our leaving ghost file

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
 
A

Alex Dybenko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top