Nirvana VBA - 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 Nirvana VBA makes use of Nirvana C# libraries it requires .Net version 3.5 or above. You can download .NET from the Microsoft Download website.

Subscribing

To access the Nirvana 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 Excel.

Microsoft Excel Versions

Nirvana VBA has been tested on Excel version 2003 and 2007. The Nirvana 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 Nirvana 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 Nirvana 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.