I am creating a macro-enabled worksheet. In it I want to list only the .xls files to perform some actions on them. I know they are all in the old Excel format, so extension is .xls. I use the "DIR" command to loop through all files in the folder using the "*.xls" filter:
lsFile = dir (lsCurrDir & "*.xls")
However, this gives me also all .xlsx, .xlsm etc files. How can I change this illogical and unwanted behaviour?