DIR command gives unexpected / unwanted results

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:

Please Login or Register  to view this content.

However, this gives me also all .xlsx, .xlsm etc files. How can I change this illogical and unwanted behaviour?

Thanks for your reply.

My workaround is similar:

Please Login or Register  to view this content.

Point is not that I do not know how to filter out the unwanted files. Point is that this should not be necessary. It is remarkable that in Windows the Command Prompt shows the same behaviour.

dir *.xl gives no results (as expected)
dir *.xls also gives results like ...xlsm, ...xlsx, ...xlsq (the latter isn't even an existing excel extension)

I consider this a bug, or a judgement error from Microsoft. It is illogical, because if I wanted those files I would issue a "Dir *.xls?" command. This kind of behaviour makes scripting and programming unreliable. Not to mention the time and energy needed to check and correct older scripts.

But this is another kind of discussion. Just was curious if there is a setting in Excel / VBA to change this behaviour.

Rorya

That is correct, but that shouldn't matter. Point is that if my searchpattern is *.xls, it should not be interpreted as *.xls?, or even *.xls*. Again, I consider this a bug: it should not happen. But probably Microsoft would remark: "This is by design.". Well, bad designer . He should be fired. (Just kidding, but he could have done better.)

I'll mark this thread as solved.