set excel=createobject("Excel.Application") set wb=excel.workboo

How open an excel sheet in QTP(not a run time )?

Question Posted / bhavani

Answer Posted / bhavani

set excel=createobject("Excel.Application")
set wb=excel.workbooks.open "path of eccelsheet"
set ws=wb.worksheets "sheetname"

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is description object?

2006

How to handle dynamic objects in quicktest professional?

902

Have you used xml check point in your project?

940

What are the Test design techniques you uses in ur project?

1916

Hi All, I need code for how to execute qtp scripts from excell sheet

1871

Mention the different actions types of qtp.

981

How to test login module with different username and password by using data driven testing in QTP?

1093

Where to use Property Let, Property Get, Property Set in UFT

789

What are the things(properties, and other details) will be recorded while recording an object using normal recording?

1934

how to acess a test in RSA?

2177

How will you handle java tree in qtp?

1058

What is the registration process and examination fees?

1022

What is quicktest professional?

974

What is qtpro? What is quick test pro?

1011

What is the difference between analog and low level recording?

1058