Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2008

Tip: Looking for answers? Try searching our database.

Searching through Subfolders

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark - 15 Apr 2008 21:54 GMT
Hello

Wondering how to do a search for .htm files that are all under one
main folder, but also through a bunch of subfolders under the main
folder.  The code I have so far is:

   myPath = "C:\MySites\"
   workfile = Dir(myPath & "*.htm")

Using this code I can only return files that are in MySites and not
the subfolders within that folder.  Is there a way to do this or do I
have to name each folder within MySites?

Thanks very much
Mark
Dave Peterson - 15 Apr 2008 22:35 GMT
Ron de Bruin shows a couple of ways:
http://www.rondebruin.nl/copy3.htm
and
http://www.rondebruin.nl/fso.htm

> Hello
>
[quoted text clipped - 11 lines]
> Thanks very much
> Mark

Signature

Dave Peterson

Tom Hutchins - 15 Apr 2008 22:36 GMT
Chip Pearson has instructions and a sample file you can download to create a
folder/file tree view - maybe that will work for you, or provide a good
starting point:
http://www.cpearson.com/excel/foldertreeview.aspx

Hope this helps,

Hutch

> Hello
>
[quoted text clipped - 11 lines]
> Thanks very much
> Mark
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.