I have a folder with multiple sub-folders, 7 actually, each folder with 5 - 7 files. Files are a random mix of PDF, *.doc, *.docx, *.xls, *.xlsx formats. Is there a routine that can be run that extracts the name of each file into an excel "index/table of contents" for easy reference? Having a method to conquer this would be a huge help.
File Name List
- Thread starter umizoomi
- Start date
Hi:
You may want to check this link
http://excelribbon.tips.net/T011144_Pulling_Filenames_into_a_Worksheet.html
Thanks
You may want to check this link
http://excelribbon.tips.net/T011144_Pulling_Filenames_into_a_Worksheet.html
Thanks
Chihiro
Excel Ninja
Since you have subfolders that you want to check, I'd go with Scripting.FileSystemObject. While it's a bit slower, it's much easier to traverse through subfolders.
There's example code found in below link. Note that you need to add reference to Microsoft Scripting Runtime (as explained at the top of the link).
http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html
If you want to list File Name with full path (instead of just file name) then replace below line in "Sub RecursiveFolder".
With
There's example code found in below link. Note that you need to add reference to Microsoft Scripting Runtime (as explained at the top of the link).
http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html
If you want to list File Name with full path (instead of just file name) then replace below line in "Sub RecursiveFolder".
Code:
Cells(NextRow, "A").Value = objFile.Name
Code:
Cells(NextRow, "A").Value = objFile.Path