I have a main folder, which has 50 subfolders, some of which each have 2-10 subfolders under them. Using the macro in Post #2 here, I was able to get a list of the first tier of subfolders. Is there any way to modify that macro to list all levels of subfolders?
Here is a recursive solution based on the code you linked. Let me know if you need to show indentation to indicate depth.
I love it when a recursive solution is the most elegant for a problem.
Please Login or Register to view this content.
hi Mustang,
Welcome to the Forum
This wee collection of macros from my personal.xls may work for you. I suggest adding them to a separate module & giving it ago by running the first macro (which calls the others)...
Edit (after posting I saw post # 2): 6Stringjazzer beat me to it, but here's something very similar.
hthPlease Login or Register to view this content.
Rob
Last edited by broro183; 03-02-2010 at 02:36 PM.
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
6String - that works great! If it's possible to have indentation as well, that would be most helpful...
Rob - thanks very much for your help. I'm going to hold out for 6String's response before I try yours out...
This revision will indent the folder name in the first column. You can apply the same thing to other columns as desired.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks