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 the genaric function to connect Sql Server using Sql Server Authentication and Windows Authentication

1 Answers  

---

Synchronozation types in QTP

11 Answers   Diebold,

---

I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .

0 Answers   Livetek,

---

Have you ever written a compiled module? If yes tell me about some of the functions that you wrote.

1 Answers  

---

How to make Shared object repository in qtp 9.1 and 9.2?

2 Answers  

---

how u will describe testing activities?

2 Answers  

---

what are the mandatory properties in qtp? what are the library functions in qtp?

3 Answers   Wipro,

---

How to test results for qtp ?

0 Answers  

---

explain keyword driven framework?

2 Answers   Mindlance,

---

what is the difference between DATA TABLE and DATA SET?

2 Answers   Accenture,

---

what is the exact testing process in qtp plz explin ?

2 Answers  

---

What is an Regular expression doing in VBScript?Tell the pattern for the email verification.

0 Answers   Accenture,

---