Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subfolder Loop? But, only one....
Hi,
i am having trouble with this one. i'll try to explain the best i can. I have a folder named 'homogeneity testing'. there are hundereds of subfolders in that folder, for instance, 400501, 400502, 400503....and so on. But, there are several subfolders in these as well. In each first subfolder, say folder 400501, there is a *lkg_5.xls file i need to extract from. i don't want to go any further than this first subfolder as there are more *lkg_5.xls files in the deeper subfolders. Basically, i want my macro to LookIn C:\homogneity testing\ then look in the next subfolder, '400501' for the *lkg_5.xls file and perform the functions i have set out. then, when done with that file, close and move on to next subfolder, '400502', while skipping the subfolders under '400501'. i think, Maybe, i need a Loop to search only ONE subfolder under 'homogeneity testing' then move on to next dirct subfolder. But........i can't seem to figure out anything that specific. i can only write code to search all subfolders. Anyway, sorry this is so long and still not very informative. Any help will be greatly appreciated. take care Live Long and Prosper! SF |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subfolder Loop? But, only one....
SF,
Use an outer loop (and set the SearchSubFolders to false, along the lines of Dim i As Integer For i = 501 to 999 ... ..Lookin = "homogeneity testing\400" & i ..... ..... Next i HTH, Bernie MS Excel MVP "foamfollower" wrote in message om... Hi, i am having trouble with this one. i'll try to explain the best i can. I have a folder named 'homogeneity testing'. there are hundereds of subfolders in that folder, for instance, 400501, 400502, 400503....and so on. But, there are several subfolders in these as well. In each first subfolder, say folder 400501, there is a *lkg_5.xls file i need to extract from. i don't want to go any further than this first subfolder as there are more *lkg_5.xls files in the deeper subfolders. Basically, i want my macro to LookIn C:\homogneity testing\ then look in the next subfolder, '400501' for the *lkg_5.xls file and perform the functions i have set out. then, when done with that file, close and move on to next subfolder, '400502', while skipping the subfolders under '400501'. i think, Maybe, i need a Loop to search only ONE subfolder under 'homogeneity testing' then move on to next dirct subfolder. But........i can't seem to figure out anything that specific. i can only write code to search all subfolders. Anyway, sorry this is so long and still not very informative. Any help will be greatly appreciated. take care Live Long and Prosper! SF |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a workbook by creating a folder & subfolder | Excel Worksheet Functions | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Excel links to subfolder | Excel Discussion (Misc queries) | |||
Importing from a subfolder in your Inbox into excel | Excel Discussion (Misc queries) | |||
how to step thru only one subfolder of a folder to find like files | Excel Programming |