View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Papou Papou is offline
external usenet poster
 
Posts: 67
Default Run Macro on true statement

Hello Jack
If Dir("C:\My Documents\Excel\Tests\file.xls") < "" Then
macro1
End If

HTH
Cordially
Pascal

"Jack S." a écrit dans le message de
...
I need a macro to determine if a file is present in
another directory and if so execute another macro
Something like:

If
\path\file.xls = true
Then
Application.Run "Prn"

End If

Thanks