VBA code to list all folder names in excel

[rockybalboa]

Can anybody give me a code to list down all the folder names from a path in excel sheet.

Thanks

[GTO]

Here is one example (untested) that happens to be written in WORD. http://www.vbaexpress.com/kb/getarticle.php?kb_id=1070

The FSO used will be the same in Excel, so I am confident that it would be easy to convert. If you search the vbaexpress knowledgebase, I am sure you'll find other examples.

Hope that helps,

Mark

[rockybalboa]

Thanks

[Kenneth Hobs]

This may be of help. http://www.vbaexpress.com/forum/showthread.php?37433

[rockybalboa]

Thank you. Will try.

[Kiran Nikam]

Hi Can you please tell me how to open a new thread

[Kenneth Hobs]

It is explained in the FAQ. http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_posthelp_faq_item

[Paul_Hossler]

Welcome to the forum


Ken's link is a good one

Here's a larger picture, and a key idea from the link

21075





Don't be a victim of the XY Problem (http://www.perlmonks.org/?node_id=542341): tell us what your goal is. Many pseudo-problems are caused by focusing on the implementation rather than the goal. There may be a better way of reaching your goal, but if you don't tell us what your goal is, you won't get there.

And above all: be nice. After all, we are here to help you and are not being paid to do it.