Closing a specific file via VBA-code

[Willem!]

Hi,

I have some VBA-code and at a certain point I want to close a specific file. Actually I want to close an Excel file which name and location are known to me.

I think I need some code that checks wether the specific file is open and some code that then closes this specific file.

Is there such a code available in VBA? Has anyone a superb idea?

Cheers,
Willem

 

[workmad3]

Hmm... if its not open in access, my best guess would be to just find out if excel is open, and if it is, close it down through access.

Not the best with inter office automation though

 

[Willem!]

... I agree, however, that is where I am stuck.. how do I do that?

 

[Willem!]

check it out, by-passed the problem by checking out if the file exists and/or if it is open.

Sample code here: http://support.microsoft.com/kb/175923/en-us and here: http://support.microsoft.com/?kbid=213383


Cherio to y'all