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?
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 |
how to compare two bitmaps( 1. clients requirement & 2. Designed by dev) in qtp 8.2 wann clear steps
in my database haveing 3X3 (manas having 3 rows 3 colums) i want to test only (2nd row 3colum) bit how to test either script or any automation plz explain? (Chandana)
How to test whether the navigation i.e. from one page to another is working r not using QTP for web based application
How to capture text from image to word
How to give Table check points?
Hi, Any one have the crack for QTP 10.0,if so could you please send it to phanijuly10@gmail.com
tell me types of environment variables? what r they? explain details? pls give anwer any one?
if my application shows 100 records and in my database having 200 records how i can validate using QTP tool?plz exp. in detail?
what is the difference btn risks & Therads in the Test plan documentation?
Brief the process of testing with UFT?
I have to automate webpage. If I click one hyperlink2 it will take 2 hrs to open. How to automate hyperlink2?
4 Answers Cap Gemini, Polaris,
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.