Excel compare script - batch file that allows execution of Excel 2013 SPREADSHEETCOMPARE tool from command line with two files as arguments. This tool is answer to problem reported in Microsoft TechCenter: http://social.technet.microsoft.com/Forums/office/en-US/65a0b5f1-e58f-4916-b090-551bbf9c719d/problem-with-spreadsheetcompare?forum=officeitpro
Download excomp.bat and place it either in folder from which you execute the script or configure Environment Variables PATH so it points to folder where you placed this file (see further part of this README for instructions how to set Environment Variables).
Simply execute from command line following:
excomp.bat Book1.xlsx Book2.xlsx
Make sure you satisfy below pre-conditions that are required to run this tool.
Make sure your Microsoft Office installation has this tool (Office 2013 or greater), to verify this follow below steps:
- Select 'Start' and 'All Programs'
- Select 'Microsoft 2013' and further 'Office 2013 Tools'
- Within the last selection you should find application called: 'Spreadsheet Compare 2013'
For this script to work correctly you have to add to system path folder with SPREADSHEETCOMPARE.EXE executable. Usually the executable file is here: C:\Program Files (x86)\Microsoft Office\Office15\DCF\
- Select 'Start'
- Right click on 'Computer', select 'Properties'
- Select 'Advanced system settings' (note: administrator privileges is required!)
- Make sure you are in 'Advanced' tab of system properties and choose 'Environment Variables'
- Add to your PATH variable path you want to add separated by semicolon sign ';'
- Confirm changes - note you need to restart your shell/command line to apply the changes in path variables
This script creates a temporary text file that is later deleted by SPREADSHEETCOMPARE tool. If user that executes the script does not have privileges to create a new file, the script will fail.