QArchive.ORG Main Page
Home | Blog | Terms of service | Sign in
All Vista Win Linux Mac
Related Products

VBA Code Compare 0.4
Download Now
File Size: 959 Kb

VBA Code Compare 0.4

Publisher:Formula Software, In c.
Install:Install and Uninstall
Recommend VBA Code Compare Suggest to Friend

Publisher's Description:

VBA Code Compare - VBA Code Compare allows you to compare and merge any Visual Basic code embedded into a VBA project (macros, sheet code, module code etc.). This tool uses direct access for working with VBA modules. Thus, you don't have to export the source code to a file for comparing and import the edited code back. Supports Excel, Access and Word documents.

You can use this tool for comparing two versions of the same module or for working with the source code when several authors change the code simultaneously.

VBA Code Compare allows you to download the source code of two modules, compare them, synchronize (merge) different parts of code, edit the code before and after comparing and save the changes.

The interface of VBA Code Compare gives you a chance to view the comparison report in two side-by-side windows, and supports syntax highlighting of the source code of Visual Basic.

VBA Code Compare has its own File Manager consisting of two side by side windows. It allows for the comparing of two folders' contents, loading files for further work, copying files and folders etc. You can control the list of files to be displayed in the File Manager by using filters.

Feature List


- Compares files side-by-side

- Highlights syntax for Visual Basic

- Highlights differences down to the level of characters

- Thumbnail View for graphical presentation of differences


- Synchronization of fragments with differences

- Edit files and edit individual lines after comparison

- Insert selected lines from one file into other file

- Search the text

File Manager:

- Two side-by-side windows

- File filter

- Sort by Name, Extension, Date Modified, Size

- Copy, Move, Delete and Rename files.

List of Changes:

Version 0.4 from 2006-04-05


Compare VB code embedded into a VBA project

Download Now
File Size: 959 Kb

Share |

Text link code :
Hyper link code:
UBB/BLOG code:

Latest User Reviews:

Byronhenry 2010-11-23 12:58:43 #
Version: 0.4

I am very happy with the product. It worked as advertised. I did have issues comparing excel macro enabled worksheets but if I converted them to excel 97-2003 they worked fine. It would also be nice if there were a print option to print out a side by side compare.

Christopher Uliana 2010-10-19 08:57:38 #
Version: 0.4

Got the job done. Easily allowed me to efficiently compare simple VBA code in two Excel 2003 spreadsheets. Thanks!!!

Bruce 2009-10-04 07:51:23 #
Version: 0.4

Your software worked very well. This saved me many hours of manually comparing two database files. The only problem I had was that it didn't work comparing and Access 97 database with an Access 2003 database. This was easily resolved by upsizing the 97 dtabase to 2003.

Michael Montgomery 2009-09-30 10:41:43 #
Version: 0.4

While I've just downloaded this application and have not had an opportunity to use it extensively, it seems that it's use for me will be very limited.
It seems to compare code that happens to be on exactly the same line number in the two files. If the executable code that it needs to compare is not on the same line, it seems that it will always find differences; even though the code might be exactly the same but appearing on different line numbers.
This could be improved by allowing the code to be editted from within this application.
The panels that list files above where the code is displayed do not serve my purpose, because they do not appear to allow me to display files that must be accessed using URLs rather than mapped drives.

Imbattsman 2009-06-06 07:52:28 #
Version: 0.4

Does not appear to work for VBA associated with Office 2007 programs.

K Mariem 2009-05-09 16:43:07 #
Version: 0.4

I wanted to compare code in a project to itself - so this program didn't really work for me. I was looking to get a list of dependencies. I ended up doing it manually.

Thanks anyway though for providing this service. Maybe I will be able to use it one day.

JOSEAMEZAN 2009-03-27 15:00:07 #
Version: 0.4

i´m sorry not answering this before but at this moment my pc is at some PC-Shop., maybe if the disk is ok, i´ll do the installing and testing., i will let you know sooner the better.


Jose M

Lwidger 2009-03-04 19:16:41 #
Version: 0.4

Great tool - wish it had a few more options

It would be nice if it were a more complete tool for comparing VBA projects. Something akin to Scooter Software's Beyond Compare, but just for VBA projects.

Eric 2008-10-26 16:27:13 #
Version: 0.4

VBA Code Compare:

Thought your product might extract damaged VBA basic module from corrupt spreadsheet, it didn't but looks like a good product for its advertised purpose.

Francois 2007-09-24 12:02:06 #
Version: 0.4

Database application compare

I needed to compare 2 Ms-Access .ADP files (12 MB each) and ensure that the production version was up to date with latest consultant changes from the development environment.
VBA Code Compare did the job quickly and easily. Saved me a lot of time.

Morris 2007-06-07 11:08:51 #
Version: 0.4

Good but missing some definitive features

This program is great at comparing the code, the feature I really need is sadly currently absent. I have deployed several (at least 20) sheets with the same VBA module. When I update the code base, I'd love to be able to run a batch file (your command line interface is a good start) to update all the spreadsheets across the network to the latest code base.

A merge function would be useful as well, when comparing two code bases.

Caffeine 2007-06-06 13:19:57 #
Version: 0.4

A necessary utility

I can't believe that a diff and versioning system for VBA is so hard to find. They seem like something any developer would *need* to have to work on a project of any substance.

I'm really excited by VBA compare, and so far, it looks quite excellent!

There are some features, like printing diffs, edit/save and code sync which appear to not be implemented yet. Unfortunately, this makes the tool of somewhat limited use for the moment, but once these things are implemented, this will be as fundamental of a tool as VBAScroll.

It allows you to ignore whitespace, which is great, but does not allow you to ignore code comments in the diff. I sent in this recommendation; hopefully it'll be implemented.

I can't wait for this software to come out!

ps- There's no posted price yet, so I picked "fair" for the price/value field, but this was at random.

esharris 2007-04-10 08:55:46 #
Version: 0.4

It does the job.

I found some things to be non-intuitive, but the customer support guy clarified things.

Roger Crawley 2007-03-29 12:11:40 #
Version: 0.4

Comments on Excel VBA Comparison

I downloaded this tool to help me with a very specific task. I needed to compare the VBA code I have in 2 different Excel files that should be identical, I have previously done this manually and a colleague helped me to find your tool.

I found it relatively easy to use and somewhat intuitive (which is necessary as I found the help file was not very informative on most of the features)

The comparison it provides was exactly what I was looking and I found the presentation of differences very clear and unavoidable, I also really like the thumbnail feature in the left margin which ensured that I was aware of all the differences the tool found on a particular module/object.

There were a number of features I couldn't seem to use:
Insert Lines

I don't fully understand what the auto file open and auto compare options should be doing (again there is no help) but my interpretation of what they should do doesn't appear to reflect what they do if anything.

I feel that there are 2 areas where this tool doesn't do exactly what I would like:
Automatically synchronising of differences ideally on a line by line or all basis
Saving any manual synchronisations I made back into the source file. I could not find this feature IF it is available, if isn't then it is one I would like to see added. The firsttime I used this tool I spent 30 minutes reviewing and synchronising a large number of differences which I was subsequently unable to save. I then found that I had to do all synchronisation through VBE and continually run this tool against the 2 files a number of times to make sure I trapped all differences, this took me longer than the 30 minutes I spent in your tool originally

Download Now
File Size: 959 Kb