Micro Focus QTP (UFT) Forums
Type Mismatch Error using QTP - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Type Mismatch Error using QTP (/Thread-Type-Mismatch-Error-using-QTP)



Type Mismatch Error using QTP - sunillsvu - 01-19-2010

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.