Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Friday, April 03, 2009 – Permalink –

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

Labels: , ,


<Doug Klippert@ 3:56 AM

Comments: Post a Comment