Macro Enabled Workbooks *.xlsm

The /outbook1 and /outbook2 command line switches can now be used to save color highlighted macro enabled workbook files. Color is used to mark the differences. Versions prior to 2.23 would always save files as the default Excel workbook regardless of the file extension specified by the user. This would require the user to dismiss warning dialogs.

A sample command line is shown below.

"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX.exe"
/inbook1:book1.xlsm /inbook2:book2.xlsm
/outbook1:outbook1.xlsm /outbook2:outbook2.xlsm
/report:report1.xlsx /comparevisualbasic:"C:\Users\John\Documents"
/colordifferences /show

Although the command line shown here is split across several lines, make sure your one is contained on a single line.

/outbook1, /outbook2 and /show are all optional parameters. If /show is used, /report does not need to be specified.

Miscellaneous Small Changes

Version 2.21 of DiffEngineX contains the following changes:

Fixes problem when comparing by Their Calculated Values and the workbooks were saved without formula recalculation.

Small problem with hyperlink navigation fixed. Only occurs when compact contiguous changes selected and range includes commas.

Better handling of comma separated value files when using command line arguments. CSV files are automatically converted into Excel workbooks during the comparison process. As such the contents of each csv file are placed into a worksheet in a new workbook. The name of this worksheet is the same as the filename minus the .csv extension. The sheets parameter must always be specified when comparing csv files. Note that comma separated value files with identical filenames cannot be compared. A sample command is given below.

"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX.exe"
/inbook1:a.csv /inbook2:b.csv
/report:report1.xlsx /outbook1:outbook1.xlsx /outbook2:outbook2.xlsx
/colordifferences /addhyperlinks /sheets:a,b

Fixes crash when Workbook Calculation is set to Automatic except for data tables.

Fixes problem when a merged cell is the last (bottom, right) cell in a worksheet.

Invoking DiffEngineX From Your Software

Invoking DiffEngineX - Compare Excel Spreadsheets - From Software

Although DiffEngineX is not currently exposed as a COM component or DLL class library, it is possible to invoke DiffEngineX programmatically from software, as well as from the Windows Command Prompt. DiffEngineX can be driven by command line arguments. A full list of arguments is given in the help file available from the DiffEngineX menu item Help-->Help Topics-->Command Line Arguments. The list is also available on our Internet help page.

A snippet of C# .NET source code showing how to do this is given below. Although the string assigned to .Arguments has been split across several lines here, ensure that your code is on a single one.

(The /outbook1 and /outbook2 arguments are optional, if you don't want to save the DiffEngineX created reports to your filesystem. As /show has been used, the /report argument is also optional in the example below. Note that meaningful exit codes are only available from version 2.16.)

namespace CallDiffEngineXExample
private void CallDiffEngineXProgrammatically1()
Process process = new Process();
string filename = @"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX.exe";
process.StartInfo.FileName = filename;
process.StartInfo.UseShellExecute = true;
process.StartInfo.Arguments = @"/inbook1:""C:\Users\Bob\test worksheets\original.xlsx""
/inbook2:""C:\Users\Bob\test worksheets\modified.xlsx""
int exitCode = process.ExitCode;


Visual Basic for Applications (VBA) Code / Macros

Version 2.14 of DiffEngineX can compare the Visual Basic code and macros contained in Microsoft Excel spreadsheets. The new difference report is in HTML format and is viewed in your default web browser.

Find Excel Macro VBA Visual Basic for Application differences with DiffEngineX

Ignoring Numeric Changes Below Threshold

Version 2.01 of DiffEngineX allows you to specify a minimum percentage change between two numbers before they are flagged as different.

Too Many Hyperlinks Error

Excel Differences Report With Hyperlinks

Version 2 of DiffEngineX can better handle large numbers of differences, when hyperlink navigation is turned on. It can handle the case when Excel 2007 has compatibility mode turned on by default.