Compare Visual Basic Projects
in the Excel workbooks

Compare and Merge Worksheets and contents of the Visual Basic Project, including code and form controls.

Main Window
Every professional VBA developer from time to time needs to compare different versions of his code. Complex Excel spreadsheets contain thousands lines of Visual Basic Code. Even minor change in code may lead to error which can take a lot of your working hours to be debugged and resolved. One of the common ways in resolving such problems is to find version of your spreadsheet where the problem appears and compare it with previous version. By analysing differences you can quickly find source of the error in your Visual Basic Code. Or you can remove differences one-by-one and find line of code which produces error.
xlCompare performs this operation quickly and effectively. It has all features you need for VBA Project comparison. You get complete list of differences with ability to merge Code, Forms and Controls.
xlCompare - Compare Visual Basic Code
Let's look how xlCompare works in this case. Open 2 workbooks and press Compare button.
If you want to compare only selected modules, you should use Compare | VBA Modules command in the menu. This command compares 2 modules selected in the left and right pane. xlCompare can be used with any type of the Excel spreadsheet, which has VBA Project - XLS, XLSM, XLA, XLAM.

Compare Visual Basic Modules

Comparison report for VB Modules is in the Difference Browser window. As you know xlCompare shows all found discrepancies in one window.
xlCompare - Difference Browser
In this discrepancy tree xlCompare shows all modules, which are different, deleted modules and added modules. Equal modules are not shown - they will only waste the difference display. Each discrepancy has explanation - which sub\function was added or in which sub line was added\removed\modified.
Activate the discrepancy in this list and you'll be pointed into the VBA Code.
In addition to this you get color-coded comparison report in the Visual Basic Code window:
xlCompare - Compare VBA Projects
Now you can see all differences in your VBA modules. To merge lines of code you can use checkboxes, linked with every changed line or block.
In the Difference Browser and in the main menu you can use commands to save comparison report on disk, restart the comparison, switch panes, etc.

Compare Visual Basic Form Objects

VB Project comparison is not complete without Form Controls. This is the most complex task you can get. You need to manually check properties in the Excel for every control to find and merge the differences. Imagine form with several pages and 20 controls on each one! You can spend hours for this work.
xlCompare Performs this in a few seconds! Form controls are represented exactly as they look on the form:
xlCompare - VB Form editor
When comparison is completed, you get color-coded report:
VB Form comparison results
Merge functions are standard for xlCompare - every checkbox in the Difference Explorer means ability to resolve difference. So, when you check any control - it is added to another workbook.
As you can see, xlCompare has all features you need to compare Visual Basic Code in your Excel Spreadsheets.

xlCompare is an ultimate tool for Excel Spreadsheet Comparison

See Also:

Download xlCompare

Pick the version suitable for your Windows. A free trial is available to help you with the decision-making.

Current Version: 9.3.5

Build Date: 4/14/2021

Version History

During 10+ years our team is working to provide you a robust and quality software. It boosts your productivity and saves you time and money. Just look into our list of changes on the page below to imagine amount of work done on the product.

Supported Versions

Microsoft Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7

64-bit and 32-bit versions are supported

Microsoft Excel

xlCompare is based on the Spreadsheet Core engine.

It doesn't require Microsoft Excel to be installed.

Questions & Answers

Which version to choose - 64-bit or 32-bit?
If you have 64-bit Windows - install 64-bit version of the xlCompare. It allows to open larger workbooks and use full power of your 64-bit processor.
How does the 30-day trial work?
Once you decide to use xlCompare, you can run a 30-day free trial first. Including all the product features, it will help you decide which features are of the greatest value to you. Once the 30 day period is over, you will be asked to make your choice.
Are there any special requirements?
No, xlCompare is a completely independent software - it doesn't have any special requirements. You can install it on the any Windows PC. Just download, install and use.
Do you offer discounts for students?
We offer student and non-profit discounts. Just open a private discussion with us, verify your status and we will provide you with a 25% discount on the regular price. We may ask you to confirm your status with documentation, so please get ready to verify that.

Order xlCompare

Personal Use
$99.99 $69.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Free Updates
  • 1 User
Order Now
Business Use
$149.99 $99.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 1 User
Order Now
Professional, 5
Business Use
$449.99 $299.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 5 Users
Order Now
* -30% discount is valid until April 30
* Standard license is for personal use only. You can't use it for your business
* All pricing packages include FREE Technical Support and new features and hotfixes by request.
VISA logo
MasterCard logo
PayPal logo
AMEX logo

Questions & Answers

Which payment methods are supported?
Orders are processed by our e-commerce partner, MyCommerce (Share*It) (part of the Digital River), through a secure SSL connection. It supports rich set of payment methods: All major Credit Cards, PayPal, Bank/Wire Transfer, ...
Is this a one-time payment?
Yes, there will be no future payments. xlCompare is sold as Permanent License, not like a subscription. You pay once and get a lifetime license.
Do you have volume discounts?
Yes. If you are ordering 3 and more licenses, please contact us for a Coupon Code. We'll provide you a discount.
Do you collect my Credit Card information?
No. Spreadsheet Tools and Share-It do not collect your Credit Card data.
Should I order a license for my new PC?
No. If you've got new PC - you can transfer your license to this new computer. You can do it yourself in your account in the Customer Area, or send us an e-mail and we'll do it for you.
How many activations do I have?
One xlCompare license allows you to use the software on one PC. If you plan to use xlCompare on more then 1 computer - you need a license for the every PC.
Is technical support included?
Yes. Free updates and unlimited technical support is included into your license. If you have any questions - contact us to get a prompt response.
Do you work with resellers?
Yes, sure. Please contact us for getting additional information.

Need Our Help?

If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.