VBA to open up folders on drive

[CodyMonster]

I looked around a bit and I haven't really been able to find what I'm looking for.

Is there a way to have VBA loop through files on a drive to retrieve other excel workbooks?
But, without having to use the file picker? I have over 100 file folders I need to go into. And I have multiple files inside each file folder.
Each folder is labeled differently with the exception of a number at the beginning of the folder. Each workbook in the file is named differently as well.

Example.
In C:\work\stuff
I have over 100 file folders
C:\work\stuff\1_xxx
Inside folder 1_xxx
theui.xls
fjdkl.xls
ueiop.xls
C:\work\stuff\2_xxx
Inside folder 2_xxx
riep.xls
bnkld.xls
ueiow.xls

on and on until the folder reaches 120.. etc.

I'm trying to avoid doing anything manual. So popup file section would not be ideal.
If anyone has an example I could work from I would greatly appreciate it!

Cody

 

[Fluff]

Have a look here
https://www.mrexcel.com/forum/excel-questions/866125-vba-loop-through-all-files-all-subfolders.html

 

[CodyMonster]

Awesome.. let me give it a shot.