Macro to read two different formats (.xls and .ods)

[jsrakesh4u]

Hello forum

I need the macro code to read two different file formats in a folder.
I use this code to read .xls format

Please Login or Register  to view this content.

Now I want to read both .xls and .ods file formats in a particular folder.

Please do reply if anyone has idea about this.
Thanks in advance.

[JBeaucaire]

Run the macro once using that filter, then run it again using the .ods as the filter.

[jsrakesh4u]

Thanks Jerry. I did the same.

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

[jsrakesh4u]

Done...