Calling Multiple Folders

[ckara005]

So I am writing a program that needs to be able to access a sub-folder within a directory, and pull the necessary data from the 5 excel files within that sub-folder, then move on to the next folder within the directory and do the same thing for the next sub-folders automatically. I want to be able to do this for multiple folders until all sub-folders within the main folder have been analyzed. Is this possible?

 

[Jeffrey Mahoney]

Look for Recursive folders or recursive file management. It's quite a thing even if you're good at VBA.

 

[Zack Barresse]

Jeffrey is exactly right. Take a look at these links for examples.

https://www.mrexcel.com/forum/excel...basic-applications-recursive.html#post2533988
Recursion And The FileSystemObject
https://www.excelforum.com/excel-pr...s-in-folders-and-sub-folders.html#post3261766
Recursive Search using the FileSystemObject Model : FileSystemObject « File Path « VBA / Excel / Access / Word
https://www.experts-exchange.com/questions/27627033/Excel-VBA-macro-to-recurse-folder.html