List of folder names needs exported to Excel 1

[DonyBoy]

I have a folder that has 100s of subfolders. I want a list of all the folder names exported to a Excel column.

so, my input should be the main folder path. My output should be the list of all the folder names written to a spreadsheet from Cell A1 downwords.

any help will be appreciated

 

[HarleyQuinn]

I was going to write this up but I'll save myself some time

Have a look here

Hope this helps

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[PHV]

What have you tried so far and where in your code are you stuck ?
Have a look at the Dir function
You may also consider the FileSystemObject:

http://msdn2.microsoft.com/en-us/library/z9ty6h50.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DonyBoy]

Thanks HarleyQuinn.

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com