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
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
'close the book and release the excel object
set obook = nothing
set oxls = nothing
|Is This Answer Correct ?||4 Yes||0 No|
difference between recording methods and recording modes in QTP
Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji
Can we write class for vb script in Quick Test Professional?
Can you import and export data from XLS and how?
What is recovery scenario manager? When you go for recovery scenario manager?
There r 1000 rows and 1000 coloums , in that I want pickup a name of the coloumn , pls dont say in sql statements , in interview one of the interviewer said it was a wrong answer pls any send me answer its urgent
What is the condition or scenario that leads the use of object spy in qtp? (while recording we can get all the properties) then wat leads to use this?
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.
How can I pass values from one action to another in QTP ?
How to capture a window in qtp or how to take snapshot of any window while writing script in qtp
what testing activities u may want to automate?
what is the another name for blackbox testing?