Essbase Retrieve in Excel using VBA

Here is a snippet of code to place in a VBA script to retrieve data from Hyperion Essbase. If you use the code, I’d love to hear your comments on how it worked for you and how you’re incorporating Essbase data into your Excel analysis.

Sub Macro1()

Application.Goto Reference:=”retrieve”
Application.Run (“EssMenuRetrieve”)
Sheets(“parameters”).Select
Range(“a1″).Select

End Sub

Here is another presentation of the macro with the added connect prompt;

Sub Macro1()

Application.Run (“essmenuconnect”)
Sheets(“CM”).Select
Range(“A1:Z200″).Select
Application.Run (“EssMenuRetrieve”)

End Sub

Tagged as: Excel, HowTo, VBA