Check if Network Shared Excel Workbook is Open

[bdmangum]

I have an Excel workbook I built which users in my department use as a database. The workbook resides in a network folder. I built an executable which launches the workbook. The executable is simply a converted batch file which calls a vbscript file. The vbscript file is what actually loads the workbook.

My problem is that I want to prevent multiple users from opening the file, or even one user from opening it twice by accidentally clicking the shortcut twice. Since it launches from a vbscript file, I'm trying to find a method which checks the status of the workbook before opening the workbook. If the workbook is open anywhere, then I want the script to tell the user to try again later. I don't want them to have the current option of choosing between Read-Only, Notify, and Cancel.

Anyone have ideas on how to do this?

Thanks!
BD

 

[PHV]

In VBA you may use this function:

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

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

 

[bdmangum]

Problem solved, well kinda. I ended up using VBA code which I called from the vbscript. Here is a link to the VBA code I used to model my code:

http://www.experts-exchange.com/Sof.../Office_Suites/MS_Office/Word/Q_20764925.html

PHV,

I couldn't get the link to work. Thanks for the help anyways!