Answer / 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

What are the types of Object Repositories in QTP?

9 Answers  

---

some times we write user define functions.where we write main and sub program,how,where to insert the functions in qtp?

2 Answers   GE,

---

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

0 Answers   SoftTech,

---

How will you send values to a cell in a webtable using QTP?

2 Answers  

---

What is log file?How to write log file code?

2 Answers   Apps Lab, Value Labs,

---

what is the difference between seat and concerent licenses.

3 Answers   AppLabs, TCS,

---

is it possible to operate(on/off)the capslock using qtp

2 Answers  

---

We need to verify the user name & password in for the user validation. But we don't want to use the parameterization/ loop for user name and password. What is the way in scripting so that user & password will generate automatically.

11 Answers   Tech Mahindra,

---

what is difference between analog and low level recording

2 Answers   Intel,

---

Tell some commonly used Excel VBA functions?

0 Answers  

---

Hoe can we do retesting using functions please give the code for it using login page

0 Answers  

---

How to find a window is minimized or not

0 Answers  

---