I'm just trying to get a simple directory listing of my hard drive into Excel 2000. I want to bring the list of folders, subfolders, and files into an Excel sheet. Simple enough, right?
I can get the files IN a particular folder to list themselves on the sheet using the Dir function and a loop, but I can't for the life of me figure out how to get the FOLDERS and SUBfolders to list. The closest thing I've found are the "folders" and "subfolders" properties, but I don't believe these apply...
I'm just trying to get this listing for my network so the backup operator can, at any time, run the macros in this workbook and get a directory listing of what's on a particular hard drive in an Excel format where it's easy to analyze (for choosing what to backup) and gives the admin a logfile to see what's being backed up.
Any help on this would be wonderful! I've been banging my head on a wall (or my screen, rather (c: ) for 2-1/2 days!!
Thanks,<marquee behavior="alternate">neo</marquee>
This message was edited by neo on 2002-03-13 09:23
This message was edited by neo on 2002-03-13 09:25
I can get the files IN a particular folder to list themselves on the sheet using the Dir function and a loop, but I can't for the life of me figure out how to get the FOLDERS and SUBfolders to list. The closest thing I've found are the "folders" and "subfolders" properties, but I don't believe these apply...
I'm just trying to get this listing for my network so the backup operator can, at any time, run the macros in this workbook and get a directory listing of what's on a particular hard drive in an Excel format where it's easy to analyze (for choosing what to backup) and gives the admin a logfile to see what's being backed up.
Any help on this would be wonderful! I've been banging my head on a wall (or my screen, rather (c: ) for 2-1/2 days!!
Thanks,<marquee behavior="alternate">neo</marquee>
This message was edited by neo on 2002-03-13 09:23
This message was edited by neo on 2002-03-13 09:25