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
- 7216 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 |
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
What are output values and why they are used ?
How QTP recognizes Objects in AUT?
If our application contain one image while executing script application failed to show that image but you have to check that image by importing dynamically from other location... Can we use Check Points here on dynamically imported image?
what are the different data driven types?
how do u get lib files into scripting files?
How the objecs properties are identified?Tell me in Hierarchical order?
What is QTP?
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)
What is the difference between the design-time and run-time data tables?
How many types of Parameters are available in QTP? and Pls Explain with example.
To which environments does quicktest professional supports?
WinRunner 
