Vba to confirm all files are present

[Abuba3000]

Hi All,

I hope you can help. I am trying to find a macro that can check if certain files are present in their respective sub-folders before running another macro, and if not which ones are missing. I have found vba examples to check just one file but not multiple.

I basically want the macro to do the following:

• Check if File "A" is in path c:\.... , check if File "B" is in path f:\..., etc
• If all files are present, create a dialog box to ask if they want to run the Compile_report macro
• If any files are missing, create a message box with which file names are missing with a recheck dialog.

Thanks

 

[Rijnsent]

Hi Abuba,
could you please post the code you already created? (in [ CODE ] brackets), that would help me helping you.
Thanks,
Koen