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

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 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Tim" wrote in message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 04/08/2004

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


"Ken Wright" wrote in message
...
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 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Tim" wrote in
message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 04/08/2004

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Tim" wrote in message
...
ahh - i KNEW someone would've thought of it first! many thanks


"Ken Wright" wrote in message
...
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 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--



"Tim" wrote in
message
...
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




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 04/08/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.734 / Virus Database: 488 - Release Date: 04/08/2004