Using xlCompare to compare Excel spreadsheets.

All comparison command are on the Compare and Merge ribbon. We suggest you to use Compare Workbooks command. It performs complete comparison of all cells, named items and vba projects between 2 workbooks.
This command shows workbook selection dialog. You can select already opened workbooks for comparison or open workbook right now from this dialog. Use [...] button to open workbook from disk.
In a few seconds you will receive comparison report like this: