Skip to Content

SAP BusinessObjects Analysis for Office Add In - suppress exceptions (?)

Sep 06, 2017 at 06:30 PM


avatar image


Trying to automate some work with Analysis for Office queries,

1st q - is there a way to suppress messages using callback if every single report is opened in new excel application/instance, and the callback registration code is not implemented in "ThisWorkbook" section of each report being opened?

2nd q - is there a way to suppress exception message (assuming that I stick to proper way of handling messages using callback)? I get exception:

"SAP BI Add-in will be closed.

If you want to save the data in the document, you must save a copy of the document

because the data needed for the addin functions cannot be saved correctly. (ID-102001)"

It appears when I try to log on using SAPLogon API method and provide invalid credentials (intentionally as eventually I need to handle this case if end user provides wrong credentials). It does not appear when try to log in manually with wrong credentials.

Exception message result in a window pop-up (not a small pop up, but full information window which needs to be closed manually) - hence it stops running the macro until the window is closed, and error handling is not possible using the LastError property


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers