DIR
Paul
You didn't post your code, so I'll assume your code sets the file name to
the variable TheFile. You could use an IF statement like:
If Right(TheFile,1)<"m" And Right(TheFile,1)<"b" then
'Your code
End If
HTH Otto
"Paul W Smith" wrote in message
...
I want to produce a listing of all the workbooks in a folder what have the
file extension .xls.
When I use Dir(*.xls), I also get all the .xlsm and .xlsb files, which is
not what I want.
Is there a way around this issue?
Paul Smith
|