How do you check to see if a window is open?

[q4s72534]

i'm writing a script in vb.

1. Check to see if excel booklet .xls is open
true or false?





Just want to say thanks to skip. you're really helping me out.

 

[Bowers74]

This should work:

Sub FileIsOpen()
Dim wb As Workbook
For Each wb In Workbooks
    If wb.Name = "ExcelWorkbook.xls" Then
        MsgBox wb.Name & " is open!"
        Exit Sub
    End If
Next
End Sub

The wb.Name "search" is case-sensitive!

I hope this helps!


Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[MeGustaXL]

Stick your head through it..

If you hear a "CRASH! - TINKLE!" sound and your face is covered in blood, it was closed!

Chris

Varium et mutabile semper Excel