Manually you can go into Essbase - Options - Global and change the options
on the messages. If you want a more automated method then you need to look
into the API's for Essbase. In XL you can look at Essbase Help and search for
EssVGetGlobalOptions / EssVSetGlobalOption...

--
HTH...

Jim Thomlinson


"KobusD" wrote:

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?