Universal Messaging 10.5 | Developer Guide | Enterprise APIs | Enterprise Developer's Guide for VBA | Prerequisites
 
Prerequisites
Pub/Sub in VBA uses libraries written using the C# API. Please refer to the C# Prerequisites for C# specific requirements.
.NET Framework
Because Universal Messaging VBA makes use of Universal Messaging C# libraries, it requires Microsoft .Net Framework, which you can download from the Microsoft Download website at http://www.microsoft.com/downloads/.
Subscribing
To access the Universal Messaging RTD server installer please contact support. The installer will register the RTD server in the windows registry so that it can be found by the RTD function in Microsoft Excel.
Microsoft Excel Versions
Universal Messaging VBA has been tested on Excel version 2003 and 2007. The Universal Messaging RTD Server has been compiled using Excel 2003 Primary Interop Assemblies (PIA). Due to backwards compatibility, Excel 2007 is able to run with this version of PIA which means that the same version of the Universal Messaging RTD server can be run on both versions of Microsoft Excel.
Publishing
To publish from Excel, you must set a reference to the NirvanaExcel.tlb type library. To access this library please contact support. This library will allow you to create and publish events from within VBA.
The type library is essentially a wrapper for the Universal Messaging C# API to make it visible from Excel.
Macro Security
Publishing events requires code to be written in VBA. If macros are not enabled you will not see any events published as the VBA code is not allowed to run.