Ceate a root directory to select multiple files at once.

I currently am writing a code where I take multiple files at once and put some of their data into a master file. Right now my code can take a folder and read what is inside that folder and open any excel file that is in that folder. The issue is, if there is a folder within that folder it will not open that folder to check if there are more files in it. So I need to write a code that can select a root directory and let it run through all folders within the folder selected.
This is what i currently have

Please Login or Register  to view this content.

Thanks, this gave some good insight on how the directory works. With this code though, how do I copy certain cells from those open files? I was using something like this

Please Login or Register  to view this content.

but that was with the single folder picker. I have 2 different sheets that I am copying from for each file.
Thanks again for taking the time to look at this.

Hi,

The attached zip file contains files:
a. ExcelForumProcessFilesInSubFolders2.xls - Updated copy of the previous file that actually processes files and puts results in a destination file.
b. ExcelForumDestinationFile.xlsx - Simulated destination file.
c. ExcelForumSourceFile1.xlsx - Simulated source file
d. ExcelForumSourceFile2.xlsx - Simulated source file with different data

The following contains code excerpts to demonstrate how the source and destination files are processed:

Please Login or Register  to view this content.

Lewis