Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there is a link present somewhere in an excel sheet.
Find the link and click on it. How to write a script using
Excel application object in QTP?
- 1 Answers
- 7218 Views
- I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 4 Yes | 0 No |
wht type of User defined functions or Java Releated functions do we write in VB scripting
Can any one explain about environment variables with examples?
Hi all. Could anyone tell me the difference between an Action and a Function in QTP. Thanks in advance and Merry Christmas.
how can we handle errors other than using recovery scenerios in qtp
How many types of Check Point in QTP
Which functionalities of QTP used in banking project? pls any say answer?
Is it possible to change the extension of Shared object repository?
What are the five challenges you faced in QTP?
how can we test the Triggers, Cursors, Indexes while doing Database testing in DTP??
Excepton Handling?
How to define array in qtp?
Hi Friends ,I want to Know name of the Site for the QTP Help and the Best Book through that I can start the QTP Practice here also whare can I download the QTP Users Guide I search I was Unable .
WinRunner 
