1.How to find in which row or column,string "Hyderabad"
exist in excel sheet?
2.How to find how many times character "a" repeated in a
given string "Koteswararao"
Answer Posted / lakshmi
Set ObjExcel=CreateObject("Excel.Application")
ObjExcel.Workbooks.Open("C:\Find.xls")
Set Obj=ObjExcel.Sheets.Item(1)
rowcount=Obj.usedrange.rows.count
colcount=Obj.usedrange.columns.count
For i=1 to rowcount
For j=1 to colcount
Aval=Obj.Cells(i,j)
If StrComp(Aval,"HYDERABAD")=0 then
MsgBox "Location Is : ("&i&","&j&")"
Exit For
Exit For
End If
Next
Next
Please let me know if you have simplest answer than this.
Thx
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Discuss quicktest professional (qtp) environment?
what are the frame work models of qtp?which frame work you follow in your company?and explain it process?
What are main panes available in qtp test browser?
How many types of recording modes in qtp?
How to find a window is minimized or not
Hi All, How to Compare two strings character by character in QTP
For which type of project the iterative model is suitable?
What are the views available in quicktest professional (qtp)?
What is the difference between Keyword Driven test and Data Driven test?
Hi ,Can any one pleas explain how to test splash objects using QTP?
In qtp, explain what is crypt object
what is the difference between data driver & data driven and driver script?
Hi Every body please explain me in steps to use checkpoints and object Repositories in QTP for Flight Reservation application please tell me the steps for this its urgent pls thanx for urs answers
Hi All, I need code for how to execute qtp scripts from excell sheet
how to prepared for first for the first interview?