Find open excel documents

[Troy28M]

I have a script that builds, saves and updates an excel sheet on the client-side. It is saved on their hard-drive and each time they perform an action, it is updated with new information.

My problem is that a few clients are opening the excel file and viewing it and then performing actions, causing the Error 1004. I need to know how or if it is possible to locate all open instances of excel and/or get the filenames, so I can either close my document and reopen, or just update the open document and then save/close.

Thank you.

 

[PHV]

You may have a look here:

http://www.xcelfiles.com/IsFileOpenVBA.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886