Hi guys. I really need someone to amend this macro for me if possible please!!!
The macro will basically look for any files containing the word "Exceptions" in its filename and move them to a folder called EXCEPTIONS.
I would like a few amendments to this macro if possible:
1. I would like the macro to search in 2 specific locations for files containing "exceptions" in their filename:
ThisWorkbook.Path & "\FORMATTED"
and
ThisWorkbook.Path & "\ONE - FORMATTED"
2. I would like all of the applicable files to be moved into a folder called EXCEPTIONS located at:
ThisWorkbook.Path & "\EXCEPTIONS"
Note: This folder may need to be created.
If someone could do this it would be very much appreciated.
Thanks!
Dave
Bookmarks