check for a file

[Keith]

I have a routine that uses the kill command to remove old versions of a
file before it creates a new version.

However if the routine is being run for the first time and the files it
has been asked to kill don't currently exist, I get an error message and
the rest of the script doesn't run.

How can I check to see if the files exist before running the kill command?

Anybody know?

Regards

Keith

 

[Allen Browne]

Dir() should do the job.
Returns a zero-length string if there is no file.

 

[Van T. Dinh]

You can use Dir to check before killing as Allen advised.

Another way is to use "Om Error Resume Next" before Kill (and switch back to
normal error-trapping after Kill). This way, when Kill errors out, VBA will
just clear the error and resume with the next statement.

 

[Keith]

Thanks,

The on error would work best since the directory I am checking has lots
of other files in it, and is never empty.

Thanks

Keith