I have been able to use code from the following discussion,LINK, to loop through a folder and run a macro on all matching files in that folder, one by one.
I have a file structure that looks like this (and I cannot adjust it):
PARENT FOLDER-Folder 1-FILE1.XLSX-Folder 2-FILE2.XLSX...-Folder NI'd like to either use that existing code to also look in subfolders for matching files and run the marco on those too. I found code in my search that used a deprecated Filesearch function, but in Excel2010 it won't work.-FileN.XLSX
The macro I run ends up exporting data to subfolders within the activeworkbook's directory which is why I cannot change the file structure. I imagine there's an easier way compared to the code I've been currently trying (works well, has some bells & whistles though).
I would greatly appreciate any help.