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

Why qtp the best testing tool?

1011

---

How to modify object property in qtp ?

1004

---

Is it possible to split an action? How?

1111

---

How to execute a winrunner script in quicktest professional (qtp)?

961

---

What are the features and benefits of quick test pro (qtp 8.0)?

1144

---

How to create scenario selector

2096

---

How do you configure QTP AND Test director?

1936

---

what is the difference between modular framework & datadriven framework

2092

---

Hi Friends this is kumar i would like to request to all of you ,please help me to explain real time project with using qtp scripts i know basics of qtp but it won't workout on interviews,pls help awating to reply.

1826

---

what is test scheduleling?

2518

---

WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT

2142

---

Why script error occur in between recording in qtp?

2272

---

Explain the types of object repositorys in qtp?

1091

---

For which type of project the iterative model is suitable?

1775

---

how interviews will be on QTP?

1934

---