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 is reusable action?

0 Answers  

---

w is output value

3 Answers   MBT,

---

What we are looking for is to load properties of object dynamically as for our application the global repository will pretty huge. It will be really helpful to us if something similar to following functions of Winrunner is available in QTP. #Define descriptor auto strDesc; #set property in the descriptor Gui_desc_set_attr(strDesc,?Class?,?Edit?); --- put other properties #Add Edit box to GUI Map Gui_add(? ?,strWindowName,strEditboxName,strDesc);

0 Answers  

---

I am using environment variable xml to give credenatials for login into unix. Is there any way we cam mask the password in the xml?

0 Answers  

---

where is the bitmap checkpoint be saved

3 Answers  

---

I installed QTP 9.5 on vista. Can someone please provide me the license key of the same. Thanks, Avi

2 Answers   Xavient,

---

There is web page with the webtable,this contains some data, how do you manipulate the data.

2 Answers   Tech Mahindra,

---

What is Virtual Users?

1 Answers   Crea,

---

i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet

0 Answers   IBM,

---

How to create configuration scripts

1 Answers  

---

When to Insert transactions in QTP?

3 Answers   Siemens,

---

Which scripting language used by QTP?

1 Answers  

---