VBA code to list all the workbooks/file names in multiple folders (within another folder)?

[Enigmachrysalis]

So I have ~5 folders with 4-8 files within each. These all reside in another folder location.

Is there a quick snippet of code that will navigate to this location and list the name of the workbook/file?

 

[Logit]

.
http://learnexcelmacro.com/wp/wp-content/downloads/File_Manager.xlsm

 

[Enigmachrysalis]

I gave that a shot but the tool tells me my folder location doesn't exist?

 

[Logit]

.
Not certain what to tell you. The download works as expected here.

 

[Enigmachrysalis]

No, the download works fine and the file opens without error, but when I paste my folder location, or navigate there using the Browse button it tells me it doesn't exist.

 

[Yongle]

Not getting involved here, but is your folder on
- your C drive?
- a server?
- 3rd party server like OneDrive?

 

[Enigmachrysalis]

Not getting involved here, but is your folder on
- your C drive?
- a server?
- 3rd party server like OneDrive?

It is a network/shared drive.

 

[Yongle]

Suggest you test with folder location on C drive - that will probably be OK and behave as expected
If so, you will know that the VBA works and that it's the path to the shared folder that is not being recognised.

 

[Enigmachrysalis]

Suggest you test with folder location on C drive - that will probably be OK and behave as expected
If so, you will know that the VBA works and that it's the path to the shared folder that is not being recognised.

So I got it to work when I browsed to the intended location. What's odd is that I clicked the 3 types of Excel file extensions to no avail; it seemed to run and listed nothing. However, if i choose al file types it gives me the names of everything down through the subfolders.