Friday, January 15, 2016

Where have all the Bytes gone?

Folder size list

You can create a list in Excel of all the folders on a drive and their sizes.
(The credit goes to Peter Beach, an Excel MVP.)

Get Folder Size code

  1. Copy the code and open Excel.
  2. Press Alt+F11 and, if necessary, on the Visual Basic Editor menu, Insert>Module
  3. Paste the code.
  4. You could use Alt+Tab to bring the worksheet forward.
  5. Go to Tools>Macros and run the Macro named "GetFolderListing".

It may take a little time to complete. BTW, if you feel geeky enough, here is a picture of some of the year 2005 MVPs from John Walkenbach's site.

See all Topics

No comments: