I have extensive experience automating Essbase through Excel via the API.

Start by downloading the demo in the EB_Pull_All_Sheets.zip from the
Contextures website:
http://www.contextures.com/excelfilesRon.html

The file is in the External Data section
with the heading "Pull Essbase Data into all Worksheets"


Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"KobusD" wrote in message
...
I have written some VBA code to retrieve information using the Essbase
add-in. I am able to manage the Excel errors and warnings so that the
code can continue without intervention from the user, but I am not
able to do the same with the Essbase errors & warnings.

Has anyone had any experience with this so that I can be pointed in
the correct direction?