yet again my box is haunted... this time I changed some email values in an excel sheet and QTP can no longer import it! it throws the error message of: "The DataTable.ImportSheet operation failed. Invalid file."
for those that will ask here is the code that worked before.
DataTable.ImportSheet "C:\Program Files\Mercury Interactive\QuickTest Professional\Tests\results.xls", "user_data","user_data"
When I cut and paste the path of where the excel sheet is located the excel sheet comes right up.
let me know if anybody has ever experienced anything like this. i didn't find anything on the forum....
ok, I think that I found the issue... I went through my excel file and took out the email names. (some of them are private) and changed them to ...@website.com. suddenly I can import the excel sheet again. so I believe that doing that reset the sent/notsent flag.
so, if anybody out there has an issue that is similar... change any email "mailto" links and have them reset.