import of xls file generated by qtp fails. works if I save it as a new file in excel
Sorry, I did a search but could not find an answer.
I am just learning this and stumbled into something weird.
I qtp, I have it create a xls file.
I have it enter information and save.
then I tried to import the file into the datatable but it fails with an invalid file message.
If I open the file in excel and save it as a new file name and just run the import code in qtp, it runs find and imports correctly.
my save seems to be correct as the file shows up with the added data.
is there some parameter I am missing?
I then add some data just having it put numbers in the first column.
the import is
datatable.importsheet "same path", "Sheet1","Global"
I even took the data out incase, but made no difference. the blank sheet gives the same error.
I am running office 2007 and have it set to save by default as xls file 1997-2003 type.