Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to use VBA to determine if shared Excel workbook being used?
I have an application in Access 2K where I write some data to, and run a macro in, an Excel workbook. The workbook can be shared by various users on a network. For the procedure to run, the workbook must be closed. How do I determine if anyone has the workbook open, and if so...- krisa
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
