MrExcel Publishing
Your One Stop for Excel Tips & Solutions

test if workbook is open?

Posted by RoB on October 09, 2001 9:08 PM

How would i test to see if another workbook is open?

I want to do this in an If statement in a macro.

any ideas? thanks

Posted by Osvaldo Ardiles on October 10, 2001 1:45 AM

There are a few ways to do this. Here's one :-

On Error Resume Next
If Err <> 0 Then
MsgBox "Book1.xls is not open."
MsgBox "Book1.xls is open."
End If
On Error GoTo 0

Posted by RoB on October 10, 2001 6:45 PM