I'm struggling with a piece of code that takes 8 minutes or more to run and I'm looking for a faster solution.
In the code, "FullPath" is the directory within which I need to look. Undeclared variables are global.
Purpose of code:
1. within the target directory, find folders which have been modified within a date range
* The directory has over 10,000 folders inside.
2. Search each identified folder (1 level deep) for a spreadsheet that contain "abcde" in the name.
3. if found, add file details to arrays for later processing.
I've seen some ideas using Dir to speed up loops, but I can't see how to use it in my situation, since I'm looking at sub-directories for files.
Any ideas are appreciated.
Bookmarks