Interested to Buy Any Domain ? << Click Here >> for more details...
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"
- 6 Answers
- 14510 Views
- Ness Technologies, I also Faced
- E-Mail Answers
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
can i compare two databases using QTP ?
Why do we use breakpoints in QTP?
When I click on a link in web page.Link should open in new window.can anyone please let me know the script for this ---Koti
can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.
How to save your test using quicktest professional?
What is difference between run time object and test object?
How to release all resources file from the QTP?
I have written a code to fetch values fro access db and place in the fields. Iam using GetROProperty to fetch runtime values. Now i want to add runtime values to the access db in field v3. please help me. Its not writting in the db. Option explicit Dim con,rs,db,c Set con=createobject("adodb.connection") Set rs=createobject("adodb.recordset") con.Open "Driver={Microsoft Access Driver (*.mdb)};dbq=D:\Sales.mdb" rs.open "select * from tax",con Do while not rs.eof Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("incost").Set rs.fields("v1") Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("intax").Set rs.fields("v2") c=Browser("Sales Tax Calculator").Page("Sales Tax Calculator").WebEdit("outtax").GetROProperty("value") rs.MoveNext print c Loop Do while not rs.EOF rs.EditMode rs.Fields("v3").Value="3" rs.Update rs.MoveNext Loop Set rs=nothing Set con=nothing
How do you perform Regreession Testing?
What are the five challenges you faced in QTP?
What is the difference between Keyword Driven test and Data Driven test?
What the differences are and best practical application of Object Repository?
Define Error Pane of UFT?
1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?
Explain the parameter in qtp?
