View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default existing file excel2000 macro

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