Till last week we have been using MS Office 2003.
Currently some of our systems were upgraded to MS Office 2007
We have a code to import the datasheet which imports .xls files.
Now that the extension of the files is .xlsx we will have to change the above code to
After changing it the scripts are running fine in my system where as the scripts throws an error when i execute in the systems still with MS Office 2003.
How can I make the code compatable for both MS Office 2003 and MS Office 2007. Can some one help me on this?
Thanks in anticipation.
QTP doesn't support xlsx format. You will have to use xls format.
If you are using MS Office 2007, even then you can save your files in .xls any how your old .xls files will support both MS Office 2007 as well as MS Office 2003
when things gets harder ,the harder gets going
U can save the new xlsx in the .xls 2003 - 2007 format, which is supported by qtp. Do uncheck the checkbox 'Check for Compatibility'
Winds of Change
Thanks for the replies