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

write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..

2253

---

What is action?

940

---

Hi all can any one give me roles and responsibilities for QTP (not WINRUNNER)

3647

---

Brief the process of testing with UFT?

1018

---

How to import a test case present in ".xls" file to TD under a Test set?

1177

---

how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

4493

---

How to integrate the qualitycenter with qtp

2203

---

How can you exit from an action?

996

---

What are the types of data tables in qtp?

930

---

hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.

1809

---

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

888

---

How qtp recognizes the object?

1102

---

Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)

2041

---

What is the process of synchronizing qtp and aut?

973

---

How to delete an object from the object repository?

1037

---