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 is the difference between byref and byval in qtp?

1021

---

1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.

2088

---

We stored into the objects OR and then write the scripting

1979

---

I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .

2195

---

Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

3387

---

How would you directly trigger javascript in a test?

1852

---

How will you test a keyboard?

1053

---

what is Property......End Property loop? how to write sript for it in QTP

2341

---

when I was doing the web testing with QTP using with standard checkpoint the Object selection -checkpoint properties dialog box not displaying pages and links hierarchical order. Could you please tell me. thanks

2229

---

What is the registration process and examination fees?

1022

---

How can i use virtual objects? If have i created one new virtual object in a virtual object manager by following instructions.

1888

---

before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...

8052

---

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

968

---

How to build scripts that access data from external sources?

2063

---

Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project

2043

---