ExcelFilePath1 = InputBox("Please Enter the Path of first Excel File")
Set fso = CreateObject("Scripting.FileSystemObject")
If (fso.FileExists(ExcelFilePath1) = false )Then
msgbox ExcelFilePath1 & " doesn't exist."
wscript.quit
End If
ExcelFilePath2 = InputBox("Please Enter the Path of second Excel File")
If (fso.FileExists(ExcelFilePath2) = false )Then
msgbox ExcelFilePath2 & " doesn't exist."
wscript.quit
End If
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = false
Set objWorkbook1 = objExcel.Workbooks.Open(ExcelFilePath1)
Set objWorkbook2 = objExcel.Workbooks.Open(ExcelFilePath2)
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
'Highlights in green color if any changes in cells (for the first file)
cell.Interior.ColorIndex = 4
'Highlights the same cell in the Second file
objWorksheet2.range(cell.Address).interior.colorIndex = 4
Else
cell.Interior.ColorIndex = 0
End If
Next
ObjExcel.displayAlerts = False
objExcel.Save
objExcel.quit
set objExcel=nothing
msgbox "It is Done"
Syndication
2010-03-10 @ 08:54:00 am
by Replicawatches
mbt shoes sale , ...
2010-03-10 @ 07:28:17 am
by MBT OUTLET
mbt sale ,MBT Safiri ...
2010-03-10 @ 07:27:06 am
by MBT OUTLET
mbt shoes sale , discount ...
2010-03-10 @ 07:26:17 am
by MBT OUTLET
mbt sale ,
2010-03-10 @ 07:25:12 am
by MBT OUTLET
mbt sale promotion,
2010-03-10 @ 07:24:18 am
by MBT OUTLET
mbt shoes uk direct,
2010-03-10 @ 07:23:12 am
by MBT OUTLET
mbt sale ,
2010-03-10 @ 07:14:23 am
by MBT OUTLET
mbt shoes sale ...
2010-03-10 @ 07:13:11 am
by MBT OUTLET
You are so master and your ...
2010-03-10 @ 05:50:52 am
by Tricia26Yates
We have now very good Internet ...
2010-03-09 @ 11:33:29 pm
by StephensonJoann
Did you have some knowledge that ...
2010-03-09 @ 09:27:34 pm
by SIMONDollie
Oakley and Ray Ban ...
2010-03-09 @ 08:34:35 am
by oakley
Oakley Sunglasses from Oakley ...
2010-03-09 @ 08:32:29 am
by oakley
With the most competitive prices,you can ...
2010-03-09 @ 08:31:46 am
by oakley