File Directory

[Benz]

Hi ,

Ive seen numerous examples using a file directory to get file paths etc. But
I was wondering if there is code that will build a spreadsheet that lists
just the different folders and subfolders on a particular drive that the user
chooses. Any help would be appreciated.

Thank you,

Ben Z.

 

[Tom Ogilvy]

Search google groups for this group and the dir command

http://tinyurl.com/2ys2vs

 

[Ron de Bruin]

I also like this simple way Tom

This in a .bat file

@echo off
dir %1 /-p /b /o:gn /s > "%temp%\Listing.txt"
start notepad "%temp%\Listing.txt"
exit

You can add this option to the shortcut in Windows so you can run it for the active folder
Dave and Gord posted this I believe

I can't find the KB that show you how to add the shortcut to run the bat file in windows
I am sure that Dave can find it

 

[Benz]

Thanks Tom!

 

[Dave Peterson]

I saved it in my .bat file after Gord posted it:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q272623&

 

[Chip Pearson]

You might be interested in my DirTree add-in, available free at
http://www.cpearson.com/excel/FolderTree.htm . It can list folders only or
folder and files, with various options and details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Ron de Bruin]

Thanks Dave