Excel Error when running QTP script on Remote comp
I am trying to run a QTP script on a remote computer . The script uses some Excel data files. I am getting an
excel error whenever script tries to import excel sheet. Method '~' of object '~' Failed. Has anybody faced this kind of error and is there any solution for this.
[ QUOTE ]
rscholz660 the Scripts and the Data files (Excel files) are stored on the remote machine .
I have tried the Err object properties which you suggested . It gave me err.number= -2147467259 and err.description= "".
[/ QUOTE ]
there are different reasons for this error. search google for this error-code. maybe you are imported a sheet wich already exist or something else. could you post your script here?
[ QUOTE ]
VBScript Errors Occured:
Error Descr.=The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.