G
Guest
Dave, I tried the code concerning IsFileOpen but I get a compile error saying
that Sub or Function is not defined.
The code I'm using is
Sub TestFileOpened()
If IsFileOpen("c:\Book2.xls") Then
MsgBox "File already in use!"
Else
MsgBox "File not in use!"
Workbooks.Open "c:\Book2.xls"
End If
End Sub
I notice that the macro applies up to Excel 97. I'm using 2007 and I find no
help topics in Visual Basic regarding IsFileOpen
Many thanks in advance for suggestions.
that Sub or Function is not defined.
The code I'm using is
Sub TestFileOpened()
If IsFileOpen("c:\Book2.xls") Then
MsgBox "File already in use!"
Else
MsgBox "File not in use!"
Workbooks.Open "c:\Book2.xls"
End If
End Sub
I notice that the macro applies up to Excel 97. I'm using 2007 and I find no
help topics in Visual Basic regarding IsFileOpen
Many thanks in advance for suggestions.