View Full Version : VBA code to list all folder names in excel
rockybalboa
04-30-2014, 12:47 AM
Can anybody give me a code to list down all the folder names from a path in excel sheet.
Thanks
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
04-30-2014, 02:07 AM
Thanks
Kenneth Hobs
04-30-2014, 06:06 AM
This may be of help. http://www.vbaexpress.com/forum/showthread.php?37433
rockybalboa
04-30-2014, 06:21 AM
Thank you. Will try.
Kiran Nikam
11-28-2017, 03:31 AM
Hi Can you please tell me how to open a new thread
Kenneth Hobs
11-28-2017, 07:20 AM
It is explained in the FAQ. http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_posthelp_faq_item
Paul_Hossler
11-28-2017, 08:20 AM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.