News And Software Release Information For DiffEngineX LLC

Our blog and older DiffEngineX release information can be found here.

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.

Excel Cell Comments

A new option has been added to compare Excel cell comments.

If a workbook of interest is compared against a blank spreadsheet, this option will effectively create a list of all the comments.

Approximate Numeric Comparisons

DiffEngineX can now treat numeric values as equal if they differ less than a specified value. This adds to its previous ability of being able to round numbers to a specified number of decimal places before comparing them.

NOTE: If you wish to compare the calculated values of formulae, rather than the formulae text itself, you should select the option Their Calculated Values.

Hyperlink Navigation

Each listed difference is hyperlinked to both altered workbook copies and originals.

Add Hyperlinks To Aid Navigation has been added to the Options dialog. This connects the difference report to every cell found to differ between two spreadsheets. Refer to our help page for more details.