View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_66_] Mark[_66_] is offline
external usenet poster
 
Posts: 24
Default Searching through Subfolders

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