Office Tips and Hints Blog

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Host your Web site with PureHost!

Sunday, February 05, 2006 – Permalink –

EXCEL

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

Copy the code and open Excel.
Press Alt+F11 and, if necessary, on the Visual Basic Editor menu, Insert>Module
Paste the code.
You could use Alt+Tab to bring the worksheet forward.
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.

[Edited entry from 2/23/2004]

See all Topics

<Doug Klippert@ 5:07 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>

<$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link