How to ensure that both .xls and .xlsx extentions respond to a command

[vivekchha]

I am using codes like
Workbooks.open("C:\XYZ\abc.xls"
Some users of my application, may have that file in 2007 version i.e. abc.xlsx.

How can I ensure that Workbooks.open respond to both xls and xlsx files.

Thanks

Vivek

[mikeTRON]

"....xl*"

Adding the * as a wildcard works for me.

[Greg M]

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[JieJenn]

Maybe try use wildcard

Workbooks.open("C:\XYZ\abc.*")

[vivekchha]

Neither abc.xl* method nor abc.* method is working. The method suggested by Greg M is working. Yet I want some kind of short method to do it. Because users of my applications may be using 2003 or 2007 or even later versions. I want some shortcut method to do it because I need it at many places in my codes.

[Greg M]

Hi again,

Does the following provide the sort of shortcut you have in mind?

Please Login or Register  to view this content.

Hope the above helps - as before, please let me know how you get on.

Regards,

Greg M