adspace


hi,
In A Table there are some columns and dynamic rows and in each
row in first column there is a link with name. upon clicking on
that link it will show some details. write the vbscript to check
that link without descriptive programming?

Answer Posted / kshama

I think the question asked was that you have to search for
"Testing" word from the name column.

Follow the below given steps:
1. prepare an excel sheet whose colums are dynamic and rows
are static.
2.Rename the "sheet1" with any name say for an eg:- "Data"
3.suppose excel sheet contains columns like Name, class and
section. and in "Name" column you have to search for the
word "Testing".
4.In Qtp write the following scipt.
datatable.addsheet"vital"
'Vital is the name of the virtual sheet in QTP'
datatable.importsheet"Pathe of the Excel sheet","Data","vital"
rc=datatable.getsheet("vital".getrowcount
MsgBox rc
For i=1 to rc
Dim a
a=datatable.value="Name","vital"
if a="Testing"
MsgBox "Testing"
Endif
Next

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B

3447


what is actually contain test report? can anybody post the test report

2095


I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com

2024


Hybrid framework supports Descriptive programming. Is it true?

1236


How are actions and functions different in QTP?

1153


we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?

2151


hi can anybody help with an qtp 9.2 license key please. Thanks, Nitesh.

2430


What is the registration process and examination fees?

1165


Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com

1864


what kind of frame work you used in your last project?

2414


Hi, how can we check or avoid the memory leakage in QTP9.2?

2168


Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ

2114


can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?

2168


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

1424


can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process

1869