Answer Posted / pushkar1206

This is working code. Don't forget to save workbook else nothing will get saved. Code is:

Set obj=createobject("excel.application")
Set obj2=obj.Workbooks.Open("C:UserspushkarDesktopBook1.xls")
Set obj3=obj2.Worksheets("Sheet1")
Set obj4=obj2.Worksheets("Sheet2")
rw=obj3.usedrange.rows.count
clm=obj3.usedrange.columns.count
For i=1 to rw
For j=1 to clm
a=obj3.cells(i,j).value
If strcomp(a,"nature")=0 Then
obj4.cells(1,2)=a
End If
Next
Next
obj2.Save
obj.Quit

Hi all Can u give me the link where we can download full version of qtp my mail id is karthic.venkitapathi@gmail.com

1844

---

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

1648

---

Explain QTP using different development techniques ?

995

---

This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10

2070

---

what is defenetion of kiran can u tell me plz CVS, SVN

2093

---

In qtp, how you can get the last character from a string?

1059

---

HOw to add the recovery file at runtime to the test file .

2252

---

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

2538

---

How can we import into Excel "Details" ,"Result" ,"Time" parameters from within a Results Report which is generated after a Run error when a script is executed in QTP? Refer E.g below Status Functionality Description RunDate Fail Login User should be able to Login 12/3/2007 StartTime EndTime Details* 1:31:58 PM 1:32:29 PM (this one i want)

2029

---

What are the various automation frameworks available in qtp?

1026

---

banking domain description for software tester for interview

3968

---

Why we load add-ins in qtp?

1156

---

What are the types of object repository in qtp?

1073

---

Dear All, How to generate Pass or Fail Report in QTP without using Reporter.Report Event Method ? Thanks Balaji

2782

---

What is ObjectParamater?

2059

---