Stop searching for file once a match is found.

I am currently running a macro that searches for a file with a rotating filename.

The current code I am using works fine. However it returns and opens multiple files. I am using numerous search criteria as the file changes daily based on the time it was saved. I am trying to figure a way to stop the search once it finds a match and continue on with the rest of the macro.

Please Login or Register  to view this content.

You could add a line saying if the workbook is added, skip the rest:

Please Login or Register  to view this content.

The above code replaces all the code you posted.

Like this perhaps:

Please Login or Register  to view this content.