Finding files that DON'T end in (1)

[dancingcab]

Hi,

My instrument spits out two text files of raw data. The analysis I need to perform is depended on which of the two files I'm looking at. The text files have the same filename however the 2nd file has (1) at the end. I can loop through half the files using

sFile = Dir(sPath & Application.PathSeparator & "*(1).txt")

But how do I loop through all the other files? Any ideas? The filename could be anything entered by the user so I don't have any more information about it other than it doesn't end in (1).

Any help would be much appreciated.

Thanks!

 

[JoeMo]

Assuming all the files of interest are text files, maybe something like this:

sFile = Dir(sPath & Application.PathSeparator & "*.txt")
If InStr(sFile, "(1)") > 0 Then
    'call a routine for the (1) type files
Else
    'call a routine for the other .txt files
End If

 

[dancingcab]

Thanks for that - I'll give it a go