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

fName = Dir(fPath & "*.xls*")

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.