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
|