Fonts changed on the website.

Version 3.18 of DiffEngineX was released on 25th July 2022. It now displays the report of Excel VBA (Visual Basic for Applications) macro differences in an integral part of its user-interface instead of using a web-browser. The HTML for these reports is still temporarily saved under C:\Users\Your-Username-Here\AppData\Local\Florencesoft\DiffEngineX\3\temp.

Replace Your-Username-Here with your Windows username.

Version 3.17 of DiffEngineX was released on 5th November 2020. It will now ignore all non-significant white space differences in Visual Basic for Applications (VBA) code modules if the relevant option is checked on the Options dialog. Now the comparison of VBA macros are handled the same way as for Excel spreadsheet cells in this respect.

Version 3.16 of DiffEngineX was released on 14th September 2020.

When Compare Folders is selected from under the Tools menu, DiffEngineX will compare all the Excel spreadsheet files (xlsx, xlsm, xlsb and xls) with the same name between two specified folders.

Now in addition to displaying the results in its user interface, DiffEngineX will generate a log file with the path and filename given below.

C:\Users\Username\AppData\Local\Florencesoft\DiffEngineX\3\compare-folders-log.txt

Replace Username with your Windows username.

We have tested DiffEngineX with the latest desktop version of Microsoft Excel on Windows, which came part of Office 365.

It seems Microsoft has introduced a problem with hyperlinks that was fixed in previous versions of Excel. In Excel 2013, DiffEngineX produced hyperlinks which worked correctly under all conditions.

As you can see in the screenshot below DiffEngineX produces a cell-by-cell listing of each difference. Each difference is associated with four different hyperlinks.

The first two hyperlinks link to copies of your two compared workbooks with the differences highlighted with color.

The last two hyperlinks link to the original, unaltered two workbooks you specified for comparison.

The problem relates to the last two hyperlinks. Under certain conditions, these two hyperlinks will fail to work.

To ensure that the last two hyperlinks work, one of the following two actions should be performed.

1. Make sure that the two workbooks you want to compare using DiffEngineX are already open in Microsoft Excel before you compare them. OR
2. After DiffEngineX has finished comparing your two workbooks, use Excel to close the two color highlighted copies of the workbooks being compared.

N.B. The bug with the last two hyperlinks is only seen when the two workbooks you wish to compare are not open in Excel before you use DiffEngineX to compare them.