Using xlCompare to compare VBA Modules in the Excel Workbooks.
When your workbooks are opened, you need to select VBA Modules button
on the xlCompare ribbon
On the next step select workbooks, which modules you need to compare, and press Compare button:
In a few seconds you will receive comparison report!
In the comparison report window you can merge differences or export them into HTML format.