Hello All,

I have a query setup in Excel that retrieves data from Hyperion using the
Essbase Add-In. Can anyone please show me how to write code that will
initiate the Retreive Data function automatically. I have a macro with input
boxes that will prompt the user to change the dimensions, but I do not know
how to automatically retreive the data via Essbase via a macro (without
manually selecting Essbase from the toolbar and clicking on Retrieve Data).

Thank you. Andy