How to tell if a file exists and then delete it

[orcinus]

Using Access 2003..

Using VBA, would like to first check to see if a file exists, say on my C drive and then if it does, delete it..

Also, would like the check/delete to involve a partial variable file name, so that the file will always have the format:

killerwhales_mmddyy.txt

where mmddyy will always be variable, so my delete should be something along the lines of delete killerwhales_*.txt

Not sure at all how to go about this, so any help is greatly appreciated..

[RuralGuy]

Use VBA Help to look up the Dir() and Kill functions.

[orcinus]

Use VBA Help to look up the Dir() and Kill functions.

Cool, found it, thanks!

[RuralGuy]

When you get things working then follow the link in my sig for directions on how to mark this thread as Solved.