Hi,
Try
If Dir("Yourfile and path here e.g c:\book1.xls") < "" Then
' Run your code here
end if
HTH,
Mark


"Foss" wrote:

Mornin' all,

I have a macro in excel that runs automatically.

I want it to check to see if the trigger file is there
before running.

The process that happens before this saves a text file, if
that text file isn't there, thir proceedure should cancel.

Any ideas?

Thanks for your help!
Foss