I have this code working fine to grab data out of multiple workbooks, but having quite the struggle getting it to work with the active path.
As it is, I place the Master workbook in it's own folder and then the individual files separate from the Master workbook. Runs fine.
As soon as I place the Master workbook in the same folder with the individual files, the code does not loop to the other files.
I added the parts in Red to skip the Master workbook which I run the code from, but doesn't work. I must be missing something easy. Any thoughts?
Bookmarks