01-19-2010, 01:14 PM
hi
I am trying to get value from a cell in Excel using QTP(vbscript).
the value in the cell is "#N/A"
this value is created by some formula in excel.(Vlookup).
i want to fetch this value.
it throws type mismatch error. Error Number "13".
Is there any way to get the value without any error.
i am working on QTP using this excel sheet.
Please provide me the solution.
Thanks in advance.
Sunil.
I am trying to get value from a cell in Excel using QTP(vbscript).
the value in the cell is "#N/A"
this value is created by some formula in excel.(Vlookup).
i want to fetch this value.
it throws type mismatch error. Error Number "13".
Is there any way to get the value without any error.
i am working on QTP using this excel sheet.
Please provide me the solution.
Thanks in advance.
Sunil.