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

Today only i joined in this site. Can u please tell me definition of parameterization. and how i can do the parameterization?

6 Answers  

---

DEFECT LIFE CYCLE,WHO PUT THE STATUS AS OPEN

4 Answers   IGT,

---

How to use conditional loops in qtp ?

0 Answers  

---

How to call a function in QTP?

4 Answers  

---

i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression

0 Answers  

---

Why QTP is termed as a Record and Playback tool?

1 Answers  

---

What is quicktest professional (qtp)?

0 Answers  

---

Using Object Repository is a advantage or disadvantage?

6 Answers   Wipro,

---

What is the current version of QTP and now it is the product of Mercury or HP

12 Answers   TCS,

---

What are the file extensions for per-action, shared object repository files and what is the extension for library files?

9 Answers   Semantic Space,

---

what is the framework followed by ur company in qtp

5 Answers   Ordain Solutions,

---

we have one text box and one list box(list box appear in same page or another page) what ever the text enter in text box that must be displyed in list box as first one. for example if we enter 10 in text box that is the 1st item in list box . after that we enter 11 then 11 is the 1st item and 10 is 2nd item. the maximum limit of list box is 10 items. if we enter 11th item the 10th item is deleted and llth one is add as 1st one and 9th one goes to 10th position part2:maore than the answer for this question i want the the reason why testers go for this kind of risk.what is the use of we testers having these kind of attempts.is that not the problem with the developer .pls answer .real time users of tools.in which way these solutions help to test with r without affecting the developed souce code.

3 Answers  

---