dir function finds xls not xlsx in excel vba
I am using dir function in Excel vba programming with filter as ".xls".

But I have input files with the extension both ".xls" and ".xlsx" which have to be picked up for the process.

In many systems the macro picks the ".xlsx" and ".xls" files even though the filter specified as ".xls" in the macro.

But in some systems it picks up only "xls" files and not ".xlsx" files.

Any specific reason for this?

Thanks in advance.

Regards,
Ramprakash
dir function finds xls not xlsx in excel vba
===

I am using dir function in Excel vba programming with filter as ".xls".

But I have input files with the extension both ".xls" and ".xlsx" which have to be picked up for the process.

In many systems the macro picks the ".xlsx" and ".xls" files even though the filter specified as ".xls" in the macro.

But in some systems it picks up only "xls" files and not ".xlsx" files.

Any specific reason for this?

Thanks in advance.

Regards,
Ramprakash