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

Hi, I am learning QTP. can someone please tell me a site from where i can learn QTP scripting Thanks in advance

0 Answers  

---

Hi All, issue is related to handling pop up script generated in IE, and run on mozilla. In App Under Test, when we get the alert pop ups, we just click ok button. if we need to run the same code on mozilla it will not identify . so we will check browser if browser(*).dialog(IE object).exits browser(*).dialog(IE object).winbutton(OK).click else 'by default mozilla browser(*).dialog(mozilla object).page(*).webbutton(OK).CLICK END IF But my qustion is. Do we write the above piece of code where ever we get such kind of pop ups from the application like alert pop up, confirmation pop up.... OR do we have any other alternative way to do this by using any functions in Recovery Scebarios? If Any of u know idea please do help me in this regard. or send answer to kravimb@gmail.com

0 Answers  

---

How QTP recognizes Objects in AUT?

1 Answers   Crea,

---

How to see entire results at the same timeafter the batch run.. Cannot see the entire results at a time. Is there a easier way view everthing at same,as our batch file very large

2 Answers  

---

who QTP recognizes the object stored in object repository?

0 Answers   Infosys, Mphasis,

---

---

Greetings friends , Hope all of you are doing well. When I run a test, is it possible for me to for me to take each row from the data table , once at a time. In other words,if i have 10 rows in the global data table, say data1,data2, data 3...and so on up to data10. Can I have the value of data1 when I run a test, and next time when I run the same test (say next day), it should skip data1 as it has already used it and go directly to data 2 ??? Would be great if anybody can help me out know in this issue. Thanks & Regards !!

4 Answers   CTS,

---

How do you create a library file

2 Answers  

---

How to interact tool & application build in QTP?

0 Answers  

---

What is the extension for Recovery scenario?

2 Answers  

---

get the order no from the following orderdetails orderstring="ORD13456PNR" eg:13456

10 Answers   Oracle,

---

hi gavasker i want how to merg OR's in QTP 8.2 by QTP Plus

1 Answers  

---

Kindly help me with the following queries.. -- How to recognize webtable using QTP and how to use it? -- How would one conclude that it is a web table -- For Example, if there is a web table and I am clicking on say Cell A1, how would i know that i've clicked on cell A1 -- Kindly suggest me to use the web table better

1 Answers  

---