Consolidating multiple excel files
Need to loop through multiple folders (3 folders in same directory) and merge all files from these multiple folders.
The below code consolidates all files from a single folder (A).
Select the file you want to merge into the current document and click Insert.
Once completed, the text and other information from the document will be merged into the current document.
obviously, you would exit the loop after the Dir() fails to return a valid subdirectory name.
Follow the steps below for the type of file you're trying to merge.
These steps can be completed as many times as you want if you want to merge multiple files.