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
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
"....xl*"
Adding the * as a wildcard works for me.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi there,
Try using:
Hope this helps - please let me know how you get on.Please Login or Register to view this content.
Regards,
Greg M
Maybe try use wildcard
Workbooks.open("C:\XYZ\abc.*")
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.
Hi again,
Does the following provide the sort of shortcut you have in mind?
Hope the above helps - as before, please let me know how you get on.Please Login or Register to view this content.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks