Please, review topics below to find answer to your question

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:

Difference Browser