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.

Search google groups for this group and the dir command

http://tinyurl.com/2ys2vs

--
Regards,
Tom Ogilvy


"Benz" wrote:

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.

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Tom Ogilvy" wrote in message ...
Search google groups for this group and the dir command

http://tinyurl.com/2ys2vs

--
Regards,
Tom Ogilvy


"Benz" wrote:

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.

Thanks Tom!

"Benz" wrote:

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.

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

http://support.microsoft.com/default...EN-US;q272623&



Ron de Bruin wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Tom Ogilvy" wrote in message ...
Search google groups for this group and the dir command

http://tinyurl.com/2ys2vs

--
Regards,
Tom Ogilvy


"Benz" wrote:

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.

--

Dave Peterson

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)

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

Thanks Dave



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I saved it in my .bat file after Gord posted it:

http://support.microsoft.com/default...EN-US;q272623&



Ron de Bruin wrote:

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Tom Ogilvy" wrote in message ...
Search google groups for this group and the dir command

http://tinyurl.com/2ys2vs

--
Regards,
Tom Ogilvy


"Benz" wrote:

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.

--

Dave Peterson