how to compare two excell sheets by using vbscript??
Answer Posted / 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
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
we use a file extension .properties why is it used and where do we use it plz help me out with detailed explanation and navigation of how to use on the QTP 8.2?
what is keyword driven testing in qtp?n how is it useful?
How to automate a script in mainframes environment? I have the terminal emulator Add in. Describe in detail.
what is defenetion of kiran can u tell me plz CVS, SVN
Explain xml checkpoints.
Describe function procedure in vbscript.
I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com
How you will rate urself in QTP in the range of 0 to 5
Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..
What are the major/ important methods, functions in QTP we use realtime testing
What is TOM in QTP?
I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian
What is the short cut keys for the following?
Describe how Smart Identification is used
What are the automation metrice in your project?