15-May-2009 NEW UTILITY: List Files In Folder

This utility will list all the files in a folder and subfolders.
- It's like a big browser
- You choose:
- The folder to start at
- Whether to include subfolders
- A limit on the number of files you want to return
- Set this to a small number to test if it's working
- Then set it to a big number for your run
- Choose the format you want by formatting the cells on the sheet
- Choose your own sort order for the results
- Then Press "List Files"
- Your files will be listed
- A pivot table will be created
- You can do lots of things with the pivot table
- Create a list of folders and size of the files
- Find how many files are in the folders
- Find duplicate files
- Split out files by file type
- etc...
- You can do lots of things with the pivot table
Here's a screen shot of the main screen in Excel:
Here's the output in Raw form:
Here's one of the things you can do with the data:
- put it in a pivot table and find out the size of the files in each folder
Training Video on how to List Files In Folder in Excel:
Attachment | Size |
---|---|
list-files-in-folder-Excel-2003.xls | 292.5 KB |
list-files-in-folder-Excel-2007.xls | 313 KB |
list-files-in-folder-Excel-2007-Row-Limit-Extended.xlsm | 242.52 KB |
»
- Nick's blog
- Login or register to post comments
- 80985 reads
hyperlinks?
Hey Nick,
I create a macro that generate Hyperlinks, and now i want to put those in a new sheet,
but the file is protected so I can modify/add the sheets,
Is there a way that i can get a not protected file?
thnx Mrw
post code
post the code here, and I will incorporate..
HyperLink to files
Any way to add VB code to add a Hyperlink, to each file, so it can be opened from within Excel? I have 30,000 files in one Directory and it would be helpful if I could open them right from Excel...
Thanks!!
for previous 7/20/2012 comment I am using Excel 2010
for previous 7/20/2012 comment I am using Excel 2010
Hyperlink
Case 6
Cells(iRow, Counter).Value = myFile.Name
ActiveSheet.Hyperlinks.Add Anchor:=Cells(iRow, Counter), Address:=myFile.Path
Add Owner to Excel 2003 version
Is there anyway I can add Owner of each file to the output.
Thanks
Steve Heron
owner
Where do you see this info ?
owner
I see it in Windows Explorer and can be seen through DOS Dir command so I have assumed it is available. Am I wrong in that assumption.
Owner
I have now soted this.
Thanks
Steve
Can Owner be added to the report?
This is a great tool, was wondering if the 'owner' or 'author' has been added as a return value?
The Author and Owner are listed in the Details section of the file properties.