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

Hi All, How to get repeated word in string . Thanks Balaji

1354

---

Explain the types of object repository?

983

---

Explain actions in qtp ?

967

---

explain keyword driven framework with banking domain?

2010

---

What are main panes available in qtp test browser?

980

---

If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?

5240

---

hi i am working with vbwindow on qtp.first i am openning qtp whenever open qtp my application not open that time generated error like "Runtime error 0" and fatal error:automation error how to solve this problem pls tell me

2370

---

While spliting an action in QTP 10.0 getting an error : "This Line is a part of Script Block.You cannot split the action on this line." how to re-solve this and split the script into actions?

1901

---

Object repositories types, which and when to use?

1069

---

How will you test a keyboard?

1094

---

What does it mean when a check point is in red color? What do you do?

1077

---

Can anyone help.i need total excelsheet operations,shortcuts in testing environment from starting onwards....

2013

---

I am Facing Issues with learing datepicker 1)when i first learn datepicker as current system date . 2)if i wanna runtime datepicker value it gives error

2825

---

I have qtp 9.5 demo ver,I am not able to record the yahoo broeser.so anyone can tell me what setting i have to do in QTP for yahoo brower recording. why its not recognise the object of yahoo browser????

2713

---

Mention what are the different types of recording modes in qtp? Which will be used when?

1010

---