Andy,

How it is done depends on how open the Essbase object is to VBA. Usually, set a reference to the
Add-In through Tools / References in the VBE, then declare the proper variables, and give it a go.
Essbase should have some examples on-line, or offer support, or have a help file, or a newsgroup,
or....

HTH,
Bernie
MS Excel MVP


"Anolan" wrote in message
...
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