DIR
Many thanks to the three of you for all producing different but workable
solutions.
Mike - I was amazed too that it happened!
Thanks all.
"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
|