How to test : files are already opened or not

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to test, wheather a particular excel file is already opened or not.
Please help me
 
This function does the job:

Public Function IsOpenWB(ByVal WBname As String) As Boolean
'returns true if workbook is open
Dim objWorkbook As Object
On Error Resume Next
IsOpenWB = False
Set objWorkbook = Workbooks(WBname)
If Err = 0 Then IsOpenWB = True
End Function

Regards,
Stefi


„kris†ezt írta:
 
You are welcome! Thanks for the feedback!
Stefi


„kris†ezt írta:
 
You must log in or register to reply here.

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

Excel 2003 - VBA File already opened 6
VBA test for the existance of a worksheet. 4
What are the events get fired when Excel gets loaded with all shee 2
Very high CPU temperature, how can i fix it? 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Excel How to activate already opend PDF file through VBA code 1
Check File Open Macro 8
Open file already open by other user 16

Back
Top