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 |
With what extension you can save the list of tests in a file to run in test batch runner?
how would you go for testing a web application like any jobsite?(using manual n qtp)..pls frnds its very urgent ..i need realtime answers...thanks in advance
how to reverse a string with out using string or predefined function,ex:string is " i love india". the output should be like this "i evol aidni"
10 Answers Aspire, MNC, Omega,
in QTP we test web based application at that time what script is run? is support vb script? plz tell me
how can we group that these test cases only should be automated and in which order you execute that test cases?
hi, Can any body tell me whats the difference between the QTP and the Rational Robat ad the Silk Test and LOad Runner and are they used in any Company On the Major scale bcas I finnf Many comapny Using the Manual Testing Only Hence Askin the Question Hope I will get the Assitence .
What is the vb script when the url enter into the browser
What is the limitations of BVA?
How open an excel sheet in QTP(not a run time )?
Hi All, How to get repeated word in string . Thanks Balaji
Given a string variable contain a full name (last name, first name), using vbscripting, how can you extract first and last name and save them into two different variables.
hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me