Excel file compare (each sheet). Is there something already available?.

  • Thread starter Thread starter EPIGONO75
  • Start date Start date
E

EPIGONO75

Hello,
I'm asking myself if there is something already available to compare two excel files. (cell by cell, each sheet in the two excel).

I know a little bit of VBA but if there is something done already (maybe I can change the code little bit by myself) it would be better. ;-)

Thank you.
 
Hello,
I'm asking myself if there is something already available to compare two excel files. (cell by cell, each sheet in the two excel).

I know a little bit of VBA but if there is something done already (maybe I can change the code little bit by myself) it would be better. ;-)

Thank you.
Click to expand...

that depends how strict you want to be.
If files are almost identical you can try to use Open XML SDK
Productivity Tool. It compares xml structure.
 
Hello,

I'm asking myself if there is something already available to compare two excel files. (cell by cell, each sheet in the two excel).



I know a little bit of VBA but if there is something done already (maybe I can change the code little bit by myself) it would be better. ;-)



Thank you.
Click to expand...

Take a look at the Compare Lists Assistant at http://www.add-ins.com/compare-lists-in-excel/compare-lists-in-excel.htm. It should do what you want.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Back
Top