Do Until loop with if statement
Sandy wrote:
I am looping through files in a directory with a Do
Until ... Loop. If there is a file name with "div...".xls
in it, I need to skip it and go to the next file.
Any suggestions would be greatly appreciated!
Sandy
It's a bit hard to get specific without some of the code you have
already written, but it might look something like this:
strFileName = <first filename
Do
If Left(strFileName,3) < "div" Then
<process file somehow
...
End If
strFileName = <set to next filename
Loop Until <condition
Hope this helps,
Matthew
|