QArchive.ORG Main Page
Home | Blog | Terms of service
All
Audio & Multimedia
Web Development
System Utilities
Home & Hobby
Education
Servers
Security & Privacy
Games & Entertainment
Network & Internet
Desktop
Development
Active X
Basic, VB, VB DotNet
C / C++ / C#
Compilers & Interpreters
Components & Libraries
Debugging
Delphi
Help Tools
Install & Setup
Management & Distribution
Other
Source Editors
Business
Communications
Graphic Apps
Related Products
VBA Code Compare 0.4
Download Now
File Size: 959 Kb

VBA Code Compare 0.4

Released:2006-04-05
Last Updated:2006-04-03
License:Freeware
Publisher:Formula Software, Inc.
Language:English
Platform:Windows
Install:Install and Uninstall
Downloads:568
Recommend VBA Code Compare Suggest to Friend
Add to your Watch List Add to Watch List

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
Display:
- 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
Editing:
- 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.

Latest Changes:

* Supports Word VBA project (Word 97/2000/2003) * Supports command line options * Added ability to open .MDW workgroup files * New option: Ignore columns. This option allows you to specify ignored and compared characters ranges for each line. * Added ability to close open modules.

Screenshot:

Compare VB code embedded into a VBA project

QA Report:

VBA Code Compare Antivirus Report
Virus Scanning Report

Download Now
File Size: 959 Kb



Social bookmarks:

 Add to Delicious  Add to Technorati  Add to Blogmarks  Add to Digg  Add to Reddit  Add to Furl  Add to Newsvine Add to Slashdot Add to StumbleUpon Add to Blinklist  
RSS: Add to Google  Add to Yahoo  Add to Newsgator  Add to Bloglines  Add to Netvibes  Add to MyMSN 

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

Latest User Reviews:

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:
Synchronise
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

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.

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.

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.

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.



Social bookmarks:

 Add to Delicious  Add to Technorati  Add to Blogmarks  Add to Digg  Add to Reddit  Add to Furl  Add to Newsvine Add to Slashdot Add to StumbleUpon Add to Blinklist  
RSS: Add to Google  Add to Yahoo  Add to Newsgator  Add to Bloglines  Add to Netvibes  Add to MyMSN 


Download Now
File Size: 959 Kb

Write a Review and Rate VBA Code Compare



Search
 
Advanced Search