Only run macro if file exists?

[kertappa]

Hello everyone, please can someone help me with the following..?

I have a simple macro to open a seperate file and copy over some data.
The macro is repeated several times for different files, six in total.
Now I am trying to create a macro to run each of the six 'copy' macros, but to only run each macro if the relevent file exists. So if the file does not exist, it will not try to open it and copy the data over...

Can someone pls let me know if this is possible?

Thanks

 

[btadams]

Welcome to the board!


Check out this link:

http://www.exceltip.com/show_tip/Fi..._exists_using_VBA_in_Microsoft_Excel/471.html