Home » Blogs » Nick's blog

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

Nick's picture
Submitted by Nick on 15 May, 2009 - 19:06


This utility will list all the files in a folder and subfolders.

  • It's like a big browser
  • You choose:
    1. The folder to start at
    2. Whether to include subfolders
    3. 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
    4. Choose the format you want by formatting the cells on the sheet
    5. 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...

Here's a screen shot of the main screen in Excel:

list-files-in-folder

 

Here's the output in Raw form:

list-files-in-folder

 

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

list-files-in-folder

 

Training Video on how to List Files In Folder in Excel:

AttachmentSize
list-files-in-folder-Excel-2003.xls292.5 KB
list-files-in-folder-Excel-2007.xls313 KB
list-files-in-folder-Excel-2007-Row-Limit-Extended.xlsm242.52 KB
»

hyperlinks?

Submitted by Anonymous on 8 August, 2011 - 10:28.

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

»
Nick's picture

post code

Submitted by Nick on 8 August, 2011 - 12:43.

post the code here, and I will incorporate..

»

HyperLink to files

Submitted by Anonymous on 20 May, 2011 - 00:14.

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

Submitted by Anonymous on 20 July, 2012 - 20:10.

for previous 7/20/2012 comment I am using Excel 2010

»

Hyperlink

Submitted by Anonymous on 4 March, 2012 - 19:51.

Case 6
Cells(iRow, Counter).Value = myFile.Name
ActiveSheet.Hyperlinks.Add Anchor:=Cells(iRow, Counter), Address:=myFile.Path

»

Add Owner to Excel 2003 version

Submitted by Anonymous on 19 May, 2011 - 10:24.

Is there anyway I can add Owner of each file to the output.

Thanks

Steve Heron

»
Nick's picture

owner

Submitted by Nick on 19 May, 2011 - 10:54.

Where do you see this info ?

»

owner

Submitted by Anonymous on 19 May, 2011 - 12:18.

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

Submitted by Anonymous on 24 May, 2011 - 15:04.

I have now soted this.

Thanks

Steve

»

Can Owner be added to the report?

Submitted by Anonymous on 20 July, 2012 - 20:08.

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.

»