Multiple Folders and Contents

jstevens
GoldLounger
Posts: 2632
Joined: 26 Jan 2010, 16:31
Location: Southern California

Multiple Folders and Contents

Post by jstevens »

Is it possible using VBA to select a main folder and determine what folder structure is beneath it? What I'm trying to do is list out each folders contents. I do know how to recurse though a folder and return it's contents.

Thanks,
John
Regards,
John

User avatar
HansV
Administrator
Posts: 78857
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Folders and Contents

Post by HansV »

Best wishes,
Hans

jstevens
GoldLounger
Posts: 2632
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Multiple Folders and Contents

Post by jstevens »

Hans,

Thank you for the links.

I searched a little bit more and found a workbook example with the following code.

It works quite nicely.

Regards,
John
Regards,
John

User avatar
HansV
Administrator
Posts: 78857
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Folders and Contents

Post by HansV »

Unfortunately, direct links to Experts Exchange don't work if you're not registered - you can view the question but not the replies... :sad:
Best wishes,
Hans

User avatar
mbarron
2StarLounger
Posts: 112
Joined: 25 Jan 2010, 20:19

Re: Multiple Folders and Contents

Post by mbarron »

Use this Google search - the EE link should be the first one. Then scroll down, way down.....

User avatar
HansV
Administrator
Posts: 78857
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multiple Folders and Contents

Post by HansV »

Yep, using Google (and perhaps other search engines, I haven't tried) is the only way I know of to view EE articles without being registered.
Best wishes,
Hans