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