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 views available in quicktest professional?

1075

---

How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?

1067

---

What is active screen?

1028

---

Explain the concept of object repository and how quicktest professional recognises objects?

1072

---

Do you know how to connect database? Can you tell me the procedures?

1046

---

How to handle dynamic objects in quicktest professional (qtp)?

1001

---

banking project description for software tester

7514

---

what is the hierarchy to use properties in descriptive programming

2039

---

How can get count of list box?

1210

---

Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

1937

---

how to compare two bitmaps( 1. clients requirement & 2. Designed by dev) in qtp 8.2 wann clear steps

2156

---

How to use conditional loops in qtp ?

1104

---

What is the qtp testing process?

1099

---

How do you open adobe acrobat file in QTP and do some testing on that file ?

1115

---

Where you get the run time data table?

1089

---