Answer Posted / pravati

set excel=createobject("excel.application")
excel.application.visible=true
excel.workbook.open("path of the excelsheet")
set mysheet=excel.activeworkbook.worksheets("sheet name")
value=mysheet.cells(row no,colmn no).value
msgbox value

what function you write to do database testing with the help of qtp?

1878

---

1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.

2178

---

when u script reveiwing in which area u more concentrates?

1956

---

How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one

2159

---

I have enrolled for a QTP course which is a four weekend course.Do you think its a good way to start off learning this tool?What all do i need with me in order to become a pro at using this tool?

2199

---

I want to test my vb.net solution file using qtp. Does Qtp test only .exe file?

2241

---

How does qtp recognize objects in aut?

1091

---

Give me detailed theritical explanation about keyword driven, hybrid framework, environment variables, hybrid frame work

1968

---

Explain how Selenium is different from UFT?

1362

---

can u explain relative path architecture framework in qtp?

2075

---

hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]

2032

---

Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya

1914

---

What is the difference between Keyword Driven test and Data Driven test?

2289

---

What are the key elements available in test result window?

1242

---

Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

1939

---