Diff two excel spreadsheets

[bhaskarmurthy]

Hi,

I wanted to know if there's a way to write a macro that can perform a
diff on two spreadsheets, and possibly return it in a third
spreadsheet. At this point, any way to perform a diff (i know about
compare side-by-side, but i need a macro) would be helpful.

Thanks,
munkay

 

[Guest]

You mean something like this?

http://www.ozgrid.com/Services/ExternalFree.htm#Compare Add-in

 

[DiffEngineX]

The best and quickest way is to download the free trial of DiffEngineX from

http://www.florencesoft.com/excel-differences-download.html

After comparing two Excel workbooks, DiffEngineX generates copies of your spreadsheets and colour highlights them, along with a cell-by-cell listing of differences.

You can then compare the two colour highlighted workbook copies (colour marks the differences) using Excel's compare side-by-side functionality under its View tab.

See

http://www.florencesoft.com/better-viewing-of-excel-differences.html

DiffEngineX is classic and reliable piece of software. At the time other spreadsheet compare tools took 10 minutes to compare two spreadsheets, DiffEngineX would do it in 30 seconds or less. The competitors may have caught up now. But DiffEngineX was the first reliable and fast workbook comparision program released.