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.