Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic change of limits in for...next loop
I have a for...next loop that performs certain actions of a list of
files. These file names are the same except for a numeric identifier (i.e testfile1.txt, testfile2.txt, testfile4.txt). Occasionally the file numeric identifiers are not contiguous (see example). I have put an error trap to deal with the missing file. However, since the number of files is known (and fixed) when I skip a file number that does not exist, that means one iteration of the for...next loop has happened and therefore one less file of the total will be processed. So if there are 50 files and iterations = 50, then if the file numbers go to, say, 60, then the files numbered 51-60 will not be processed. I tried the following code to increment the for...next limits dynamically but it doesn't work. The limits remain the same. This is true if I try to adjust either the lower or upper limit. Any ideas? With Application.FileSearch .LookIn = FullName .SearchSubFolders = False .FileName = "*.txt" .MatchTextExactly = False .Execute Iterations = .FoundFiles.Count End With For Index = 1 To Iterations On Error Resume Next Documents.Open FileName:=FullName & ShortName & Index & ".txt", Visible:=True If Err.Number < 0 Then Iterations = Iterations + 1 GoTo ReturnIt End If ...do stuff to opened file ReturnIt: Next Index |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change increasment in a for loop | Excel Discussion (Misc queries) | |||
Loop with dynamic range | Excel Programming | |||
Change the FOR loop top | Excel Programming | |||
Dynamic execution of a loop | Excel Programming | |||
Using UsedRange as limits in a For Each loop but for cells on another sheet ? | Excel Programming |