vba delete

[timbo1957]

Hi,

I have written (with help from the forum) a sequence of macros for a colleague to run when I am on holiday. There are specific files that must be updated weekly.

I am trying to cover all angles for my colleague. So a hypothetical - the system goes down halfway through the procedure which takes about two hours.

Is it possible to write a macro to do the following -

Go to a certain directory say C:\SALES\

If a specific file exists i.e. Summary 080811.xls then delete it?

This would take her back to where I left off and she can just start from scratch again.