Detect if file is open

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Is there a method to detect if a file is already in use by someone, before I
open it?

Chad
 
Just use this function:

Function IsWorkbookOpen(WorkbookName as String) As Boolean
Dim Wkb as Workbook
on error resume next
Set Wkb = Workbooks(WorkbookName)
If Not Wkb Is Nothing Then IsWorkbookOpen = True
End Function


Just have to pass the workbook name to the function...if
it is open, it will return TRUE, if it is closed, FALSE

Seth
 

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

Similar Threads

Detect if spreadsheet is opened off the web 3
Detect macro in excel file without opening it 6
update links - source file open 1
Detect if an excel file is open 1
Error Installing "ADAPTEC EZCD 4.04" 1
Test if a file is password protected 2
Detecting open workbook 2
Addin - Look for a File when it is opened 1

Back
Top