reporting directory info into a spreadsheet

[Tim]

hi,

this *might* be simple: i want to search through my hard drive and report in
a spreadsheet, all of the directories into a spreadsheet. in each case in
the adjacent column, display the size of the directory (no. of files), next
column size of directory (memory).

if possible, to include: -
- directory to start from (then look at all sub-dirs from there)
- display consecutive sub-dirs as indented (eg, top level dir in column A,
next in column B etc)

if anyone can help with any or all of this, that would be great - although
i've used VB quite a bit, i haven't ever done anything like this, so not
sure how to start.

cheers,

tim

 

[Ken Wright]

Is this something you specifically want to do in VBA, or have you considered a
readymade app for this:-

http://www.jam-software.com/freeware/

It's even freeware

 

[Tim]

ahh - i KNEW someone would've thought of it first! many thanks

 

[Ken Wright]

Gives you lots and lots of nice options - Full collapse / Full Expand / Size / %
/ blah blah blah.