This procedure provides an example of how to use Essbase VBA functions in the spreadsheet using EssVConnect.
To use Essbase VBA functions in a spreadsheet:
Copy and paste the content of ESSBASE/BIN/ESSXLVBA.TXT into the module to declare all functions.
Alternatively, you can declare only the individual function that you plan to use.
In the module, using an example from EssVConnect, enter the this VBA code for the EssVConnect function:
Sub Conn()X=EssVConnect(Empty, "User1", "password", "Local", "Sample", "Basic")End Sub
Substitute your user name, password, server name, database, and application.
In Assign Macro, select the name of the subroutine from the list of functions.
The function is now associated with the button that you just created.
Select Tools, then Macro, and then Macros.
Select the function name, and then click Run.
Alternatively, you can click the button that you just created.