QuickStart: Installation (VBA)

 Sept 2010: v2 of VBA Global Error Handler is now available vbWatchdog (no DLLs!)

Installing the SimplyVBA Global Error Handler for development

The Global Error Handler is provided as a single DLL library - the filename is VBAGlobalErrorHandler.dll.

This DLL can be found on your computer in '%PROGRAM FILES%\EverythingAccess.com\VBA Global Error Handler\' (unless you changed the installation directory)

When developing using the SimplyVBA Global Error Handler the DLL must be properly installed.  The DLL does not need to be "installed" for clients - you can take advantage of the registry-free installation option instead which makes distributing applications made with this product much easier - see Registry-free client installation (DISTRIBUTABLE EDITIONS ONLY)

We provide you with a simple Setup.exe application that handles the full installation of the DLL - it is available for download here.

VBAGlobalErrorHandler.dll contains the following components:

A VBA COM Reference Library (required)

This part of the DLL is what you set a reference to from your VBA project (discussed below).

A VBA COM AddIn for displaying line numbers in the VBA IDE codepane (not essential - can be unloaded)

This AddIn is called 'SimplyVBA SourceCode Line Numberer' and can be enabled/disabled in the VBA COM AddIns Manager.  This part is not activated when registering the DLL manually with regsvr32 (or in an installation package).

An Access COM AddIn to ensure the compiled code in MDE/ACCDE files is fully compiled (highly recommended)

This AddIn is called 'SimplyVBA Compiler Fix for MDEs' and can be enabled/disabled in the Access COM AddIns Manager.  This part is not activated when registering the DLL manually with regsvr32 (or in an installation package).


Once installed, the library will be available from your VBA references window.


(Tip: Press the S key on your keyboard when in the References window to scroll down to the libraries starting with the letter S)


If you've purchased a DISTRIBUTABLE EDITION of SimplyVBA Global Error handler, then you are allowed to include the VBAGlobalErrorHandler.dll in a packaged install routine for when releasing your products.

Simply copy the VBAGlobalErrorHandler.dll from your Distributable edition over during your installation routine and then register the DLL in the normal way (using regsvr32.exe).

Remember though that you are not allowed to include the DEVELOPER EDITION of the .DLL in any packaged installation since you are not allowed to redistribute that version of the DLL. You must first purchase a DISTRIBUTABLE EDITION.

Any questions regarding licensing should be put to our sales team: sales@everythingaccess.com

Registry-free client installation (DISTRIBUTABLE EDITIONS ONLY)

If you need to distribute the DLL to clients that don't necessarily have administrative permissions to install a COM DLL Library, we give you another neat solution.

Simply distribute the DLL file in the same folder as your application .MDB / .MDE file and go to the Add-Ins menu in your VBA IDE as follows:

Install Free Pic

>> Add-Ins >> SimplyVBA Global Error Handler >> Setup installation-free DLL support

This will add four class modules to your VBA project called ErrEx, ErrExCallStack, ErrExDialogOptions and ErrExVariables.  You need not worry at all about these modules - simply understand that they provide late-binding support to the DLL. 

This method of installation provides exactly the same functionality as having the normal COM reference, but doesn't require any form of installation (... apart from copying over the DLL to the same directory as your Access project).  This completely avoids permission related installation problems and Vista elevation messages.  "DLL Hell" no more!