Answer / maruthi ram

Set objExcel = CreateObject("Excel.application")
objExcel.Visible = True
Set objWorkbook1 = objExcel.workbooks.open("D:\maruthi1.xls")
Set objWorkbook2 = objExcel.workbooks.open("D:\maruthi2.xls")
Set objWorksheet1 = objWorkbook1.worksheets(1)
Set objWorksheet2 = objWorkbook2.worksheets(1)
For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorksheet2.Range(cell.Address).Value Then
msgbox "value is different"
Else
msgbox "value is same"
End If
Next
objWorkbook1.close
objWorkbook2.close
objExcel.quit
set objExcel=nothing

Answer / deven

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook1= objExcel.Workbooks.Open("E:\Deven1.xls")
Set objWorkbook2= objExcel.Workbooks.Open("E:\Deven2.xls")
Set objWorksheet1= objWorkbook1.Worksheets(1)
Set objWorksheet2= objWorkbook2.Worksheets(1)
For Each cell In objWorksheet1.UsedRange
If cell.Value <> objWorksheet2.Range(cell.Address).Value
Then
msgbox "value is different"
Else
msgbox "value is same"
End If
Next
objWorkbook1.close
objWorkbook2.close
objExcel.quit
set objExcel=nothing

how can i pass a "cript"as a parameter in to a function

0 Answers  

---

I dont know how to configure non standard objects to standard objects in QTP9.2 can i have someone explain me in breify?

3 Answers   TCS, Wipro,

---

I have 3 add buttons of same properties in my page but i want trigger one of them i required in my recovery scnario manager is qtp recognizes it to recovre d scnario if so how qtp recognizes it

3 Answers  

---

How to export data present in Datatable to an ".xls" file?

1 Answers   Crea,

---

In Login two edit box which object class property value is same, How to enter into 2nd edit box in qtp by vbscript.

3 Answers  

---

What is the difference between Image Checkpoint and Bitmap Checkpoint?

8 Answers  

---

what is descriptive programming?

5 Answers   Ordain Solutions,

---

How to watch currnet value of an object like OK buton or edit box with "Agent Name:" label. in watch expression tab?

2 Answers   Cap Gemini,

---

what is the frame work your using in automation ?

4 Answers  

---

Whenever we use GETROPROPERTY function.

7 Answers   NIIT,

---

How to create basic scripts from a manual test case in QTP?

1 Answers  

---

What is the difference between client server application and web based application?

3 Answers   IBM,

---