Compare | Books menu command
Use this command to compare 2 workbooks.
If you have no opened workbooks at this moment in the xlCompare, the application prompts you to open 2 files.
xlCompare compares all worksheets with same names in the opened books. After comparison you get Difference Browser
window. It displays comparison results: