Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?



Suppose there is a link present somewhere in an excel sheet. Find the link and click on it. How to..

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

Post New Answer

More QTP Interview Questions

With what extension you can save the list of tests in a file to run in test batch runner?

0 Answers  


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

2 Answers   Wipro,


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

3 Answers  


how can we group that these test cases only should be automated and in which order you execute that test cases?

2 Answers   BSL,


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 .

1 Answers   First Europa,


What is the vb script when the url enter into the browser

2 Answers   Satyam,


What is the limitations of BVA?

1 Answers   IBM,


How open an excel sheet in QTP(not a run time )?

4 Answers   Tech Mahindra,


Hi All, How to get repeated word in string . Thanks Balaji

0 Answers  


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.

2 Answers   Banking,


hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me

3 Answers  


Categories