Hi,

I am trying to write a script that will run a macro on a number of files if they exist.
If they do not, it will look for another the next pre-defined file and so on, until all 16 files have been searched for and the macro run, where applicable.

e.g.

If file "C:\My Documents\Book1.xls" exists then run macro
then
If file "C:\My Documents\Book2.xls" exists then run macro

But am not sure how to combine the "If file exists" and "if file does not exist" functionality.

Anyone able to assist?