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:
However, this gives me also all .xlsx, .xlsm etc files. How can I change this illogical and unwanted behaviour?Please Login or Register to view this content.
Bookmarks