Using VbaDiff with Subversion

Development best practice recommends storing source code in repositories such as Subversion. However, Subversion is designed to work with text files, whereas VBA code is embedded in the binary Office document. This can make it difficult to utilise the full power of Subversion for VBA development.

VbaDiff alleviates this problem by working as an intermediary between Subversion and your diff tool. VbaDiff will be able to show you VBA code differences between different versions in the repository, or between the repository and the working copy.

To Configure TortoiseSvn with VbaDiff:

  1. Check out your Office document from Subversion.
  2. In File Explorer, right click on your document and select TortoiseSvn - Settings from the context menu.
  3. The TortoiseSvn Settings window will appear. Select Diff View from the left panel.
  4. On the right panel, click the Advanced button.
    Button for selecting a specific diff tool for each file type.
    Button for selecting a specific diff tool for each file type.
  5. When the Advanced Settings window appears, select the file extension that you would like TortoiseSvn to open using VbaDiff. Then click the Edit button.
  6. Replace the contents of the External Program text box with the following:

    C:\Program Files\Technicana\VBADiff_V5\VbaDiffLoader.exe %base %mine

    This assumes that VbaDiff is installed in the standard file path. You will need to modify this line if you installed VbaDiff to another path.

  7. Repeat these steps for all the file extensions that you would like to push to VbaDiff.