How to find folders in a directory

[Andrew]

Can someone show me how to write a code which will find all the
folders in a given directory and then write those folder names onto
the active worksheet? I know how to do files, I just need the
folders.

thanks,
Andy

 

[AB]

Have you had a look at Chip's brilliant site
www.cpearson.com/excel/foldertree.aspx
?

 

[Andrew]

Have you had a look at Chip's brilliant sitewww.cpearson.com/excel/foldertree.aspx
?

AB,
Thanks. That looks like what I am looking for.

Andy