Blog

VbaDiff - Video Star

Last Updated on Monday, 20 May 2013 20:51 Written by Chris Spicer Monday, 20 May 2013 20:42

Ever wanted to show your friends what VbaDiff is about? That just got easier with our first VbaDiff video on YouTube. In this video I talk about exporting code and re-importing it back into another Excel file. 

I hope to continue with a series of videos illustrating the many great features of VbaDiff.

 

7 Day licenses in VbaDiff 4.2

Last Updated on Wednesday, 15 May 2013 21:35 Written by Chris Spicer Wednesday, 15 May 2013 21:26

At Technicana we talk to our customers. We also try and talk with the ones that don't buy. One thing that keeps coming up is that some potential customers urgently need VbaDiff for the task in front of them, but don't know how often they'll use it in future. 

We've tried to figure out how to serve these customers - and have come up with the VbaDiff 7-day license! This gives you all the power of a Professional license for seven days, including the ability to view and export code. If you or someone you know finds themselves unable to open a VBA Project, or a 3rd party library is mis-behaving, get them to download the trial and see VbaDiff parse the code, then upgrade to the VbaDiff 7-day license for just £19.

(Note that you'll need to download the latest version of VbaDiff (4.2) from the trial page to use the 7 days licenses).

 

VbaDiff V4.1 Released

Written by Chris Spicer Saturday, 11 May 2013 16:54

VbaDiff version 4.1 is now available. This version adds a new option of viewing a module's code, rather than exporting it. This view option highlights the VBA code in the correct syntax, so that it's easy to pick out keywords and comments.

The second improvment is the addition of Beyond Compare 3 to the Diff tool list. Beyond Compare 3 is a great product and we're really pleased to be able to interact with it.

 

VbaDiff - Ease of Use is our Aim!

Written by Chris Spicer Friday, 10 May 2013 19:31

 

I was asked by someone today whether they would need to change their XLA add-in in any way in order to diff it. It seems some other diff tools have posted a large list of changes that need to be made before their users can diff their XLAs.
 
Fear not - VbaDiff does not require you to make any changes to your XLA. You don't have to rename it back to an XLS, or change your VBE's security settings, or enter the VB Project password. It just works!
 
VbaDiff succeeds where other tools fail because it reads directly from the document file. It doesn't start up any Excel sessions and try to manipulate the Visual Basic Editor. This approach is very complex to program, but it brings fantastic results for the end user. I wanted to make diff'ing VBA easy, so fiddling with settings and passwords would not cut it. With VbaDiff you just drag and drop two files onto the main screen and you're done!

Reference Reading in VbaDiff

Last Updated on Wednesday, 08 May 2013 19:09 Written by Chris Spicer Wednesday, 08 May 2013 19:04

An early look - still under development!

 

A screenshot of some early GUI work on references.

I've learned that there's a lot more information about references stored in the Excel/VBA file than I first thought! But progress is steady and I'm managing to extract the relevant data. My next step is to try and put the information on the GUI in the most effective way possible.

I have been thinking about how useful this could be. Ever had a situation where you've deployed a workbook to an end-user, only to find that they don't have a referenced library installed? I am imagining a tool that you could point at a workbook and extract the names of the references it uses, plus their paths. You could then run it on an end-user machine to check that those references are deployed, before sending over the file.

 

More Articles...

Page 1 of 7

«StartPrev1234567NextEnd»