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

How do you do batch testing in wr and is it possible to do in qtp, if so explain?

919

---

What is Associate Repository in QTP 9.2 ?

983

---

Tell some commonly used Excel VBA functions?

1015

---

Dear sir, i want to perform a QTP automated testing for mechancial engineering software like msc adams, msc nastran this softwares will help for mechanical engineering design analysis>> i know oad runner win runner, test director, QTp>> but i dont know how to use for automation

2040

---

suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1798

---

1. What is the difference between Keyword and function in the keyword driven framework? 2. How do you associate Keywords to the script ?

1495

---

How to creating an output value using quicktest professional?

1004

---

Explain quicktest professional (qtp) testing process?

974

---

Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

3025

---

hou can we use vb script in qtp could u tell me breafly

2149

---

What is environment variable in qtp and why to use it?

957

---

What is the difference between rational rose and QTP?

2197

---

I want to read XML file loaded in Quality center and compare the values with the values displayed in Application (web table).How can I do that

1813

---

Where can I find and view run-time data table?

923

---

How is UFT 11.5 version different from UFT 12.0?

1015

---