Complex spreadsheet models contains a lot of Visual Basic code. WCT allows you to compare VBA code between 2 selected workbooks and merge differences.

To compare VBA Modules in your should use the VBA Modules ribbon button in the Excel 2007/2010:

Or the VBA Modules item in the Compare menu in the Excel 2003:

Workbook Comparison Tool uses direct access to the Visual Basic project, so you should have the option Trust access to Visual Basic project enabled.

To start comparison you must select workbooks which will be compared:

WCT processes VBA Modules in both workbooks and displays comparison report.

• Added lines are marked with green color
• Deleted lines are marked with red color
• Modified lines are marked with blue color

All differences in this report can be easily merged using navigation toolbar in the Comparison Report dialog:

The first 4 blue buttons allow to navigate between found differences. You can go to the:

• First difference
• Previous difference
• Next difference
• Last difference

If all these buttons are disabled in your report - selected modules are identical.

Next 3 buttons are used to merge differences:

• Copy lines from left module to the right one. If you select modified lines or lines which are not found in the right module, this option moves selected lines into the right module. Modified code is replaced, lines which are not present in the right module are inserted.
• Copy lines from right module to the left one.
• Delete selected lines. Code is deleted only from the module which is currently selected.

Complete information about all toolbar buttons - VBA Comparison Report Commands topic.