Skip to Content
avatar image
Former Member

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

Hi,

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

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers