Hi,

Thanks very much, I'll give that a dig!

Cheers,
Foss

-----Original Message-----
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

.