Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching through Subfolders
Ron de Bruin shows a couple of ways:
http://www.rondebruin.nl/copy3.htm and http://www.rondebruin.nl/fso.htm Mark wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching through Subfolders
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 "Mark" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Creating Subfolders | Excel Programming | |||
please help me with folder and subfolders | Excel Programming | |||
copy subfolders, replace text in files and save files in copied subfolders | Excel Programming | |||
Get list of subfolders | Excel Programming |