hi patrick
i tried but i get the same msg either the file is open or not

Sub AAA()
On Error Resume Next
If Not Workbooks("filename.xls") Is Nothing Then
MsgBox "the file is open"
Exit Sub
Else
MsgBox "the file is not open"
End If

End Sub



"Patrick Molloy" wrote:

If NOT Workbooks("Ttt.xls") Is Nothing Then

"רוז×*ט" wrote:

if i want to check if a file is not open the macro is
If Workbooks("Ttt.xls") Is Nothing Then.....


but when i want to write it in the opposit
like: If Workbooks("Ttt.xls") Is exist Then.....
this macro did not work
what is the correct macro to the opposit of " Is Nothing"

thank you
rozent