Answer Posted / anup muralidharan nair

'Assume the link present in excel that you want to click is
'www.google.co.in

set oxls = createobject("excel.application")
set obook = oxls.workbooks.open("D:\excel.xls")
set osheet = obook.worksheets("sheet1")

'Retrieve all the hyperlinks within the sheet
set ohyper = osheet.hyperlinks
for each hyp in ohyper
If hyp.name = "www.google.co.in" Then
hyp.follow
End If
next

'close the book and release the excel object
obook.close
set obook = nothing
set oxls = nothing

Is it possible to split an action? How?

1050

---

What are the main differences of qtp and win runner?

1066

---

Hi friends did any budy attend accenture system test for qtp? if any budy pls drop questions.not only accenture any other mnc company which you attended system test(QTP)?it may helpful to others also

2270

---

hi nani my doubt is how does qtp process metrix related to software process.

1925

---

I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.

1985

---

How qtp recognizes the object?

1103

---

What is the use of text output value in quicktest professional?

916

---

The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)

3211

---

How the exception handling can be done using quicktest professional?

951

---

What is QTP scenario.

2204

---

Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..

4831

---

in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?

7076

---

Is any limitation to xml checkpoints?

968

---

If object is not recognized by qtp but the object is standard object what is your approach?

959

---

How to add object to object repository in qtp9.0 Suppose for brower yahoo home page

1789

---