Automating Essbase Client - Excel with VBScript/Macro (1)

To start Essbase-Excel VBScript programming or even Excel Macro programming you may want to look into a comprehensive help guide made by Oracle|Hyperion.

It is located on your Essbase Client installation folder. The help file name is "essexcel".  In my case it is located on "C:\Hyperion\common\EssbaseRTC\9.3.1\bin"

List of VB Functions and Macro Functions are listed on the help file, along with the syntax of programming.

You may also want to open my case study.