Interested to Buy Any Domain ? << Click Here >> for more details...
how to compare two excell sheets by using vbscript??
- 2 Answers
- 19018 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 6 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 1 No |
How many tables r created during the recording in QTP?
What issues come up in test automation, and how do you manage them?
Hi All, I need code for how to execute qtp scripts from excell sheet
My project title is "DRUG Audition and research management" it comes which domain?
How can we display the names of the buttons in the toolbar of a webpage
Explain hybrid framework with advantages and disadvantages?
CAN ANY ONE PLEASE EXPLAIN DIFFERENT TYPE OF FRAMEWORKS USED IN QTP?EXPLAIN EACH OF THEM?..POST TO VANILKUMAR_1981@YAHOO.CO.IN
Which advantages helping QTP to hold the position of "Market Leader" for such a long period?
Without using gui map editor we can recognize the application in winrunner ?
Explain about Hybrid Framework
Hello Everybody, How to maintain the page state in QTP. My scenario is: 1. I opened a notepad file. 2. Entered some text in the notepad file. 3.And changed the font type and color of the notepad file. And saved that. 4.Now next time when I will open the notepad it is showing the changed font type and color, rather than the default values. Please provide the code. Thanks, Gaytri
Tell some commonly used Excel VBA functions?
WinRunner 
