Displaying Folder Structure and Files from WIndows Explorer to Excel
 

You can use a recursive funtion using the Dir command or you can create an
instance of the FileSystemObject in the Scripting Runtime and use the
folders object.


For approaches using DIR
Put all this on one line an paste it into your browser:

http://groups.google.com/groups?as_q...ng&lr= &hl=en


for the filesytem object:

http://groups.google.com/groups?as_q...ng&lr= &hl=en

Regards,
Tom Ogilvy


"Tim Beckman" wrote in message
...
I'm looking for a way to specify a folder within Windows
Explorer and have that folder, subfolders, and files
displayed in an Excel sheet row-by-row. This will allow
for expansion and contraction of folders and modifications
of cells associated w/ folders and files. Any suggestions?