Creating Visual Basic Modules

  To use the VBA functions, you must first create Visual Basic modules to contain the VBA code.

  1. In Excel, select Tools, then Macro, and then Visual Basic Editor.

  2. In the Visual Basic application, select Insert, and then Module.

A module is displayed labeled Module1 (or labeled with the next highest module number, if you inserted one or more modules).

Tip:

You need the declarations (see Declaring Functions) in essxlvba.txt (in /ESSBASE/BIN) in order for the Essbase VBA functions to work. For convenience, copy the text of essxlvba.txt into another module.