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

Code:
--------------------

Sub RunIfPresent()
If Dir("C:\myFile.xls") < "" Then
Application.Run "Prn"
End If
End Sub

--------------------





---
Message posted from http://www.ExcelForum.com/

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