Essbase includes a library of VBA functions for use in Excel. The Essbase VBA library gives you the same functionality as the spreadsheet macros, except in a Visual Basic format with additional functions.
Three types of VBA functions are included:
The functionality of the macro equivalents matches that of the spreadsheet macros. While you can continue to call the spreadsheet macros in an Excel Visual Basic program, it is more efficient to use the library of Essbase VBA functions. For example, instead of using the EssConnect macro, you should use the EssVConnect function.
The menu equivalents are Visual Basic functions that execute the Essbase menu commands.
One function enables you to use the Visual Basic API inside Excel.
Manipulation of worksheets in VBA, such as naming worksheets or moving worksheets, may not work when Query Designer is running. |