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

What are the types of environment variables in qtp?

1005

---

Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

1877

---

How often were they executed?

2413

---

What is the difference between local and shared object repository in qtp?

1010

---

How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined

1920

---

What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????

2129

---

can any boby tell me what is method or steps to connect the remote desk top by using QTP 9.2 version?

2038

---

Hi any body pls help me for QTP 11.0 software free demo version. i have to practice. Kindly send the link.or where i have to download.

2029

---

Can UFT be connected to Quality Center? If ‘Yes’ brief the process or steps.

1067

---

What is use of object spy?

1038

---

what is ODC and GDC?

7827

---

is there any addin for remedy user application

2223

---

How to release all resources file from the QTP?

1517

---

in a web page How to check and display a particular word from a paragraph?

2444

---

Is it possible to switch between recording modes during a test creation?

1008

---