Skip to Content
0

Analysis for office - Work with BADI

Apr 10 at 12:42 PM

20

avatar image

On help.sap.com there is an information about using BADI within macro code.

https://help.sap.com/saphelp_boao22/helpdata/en/5f/5bb868b7a345e1ad239dcfb66c58dc/frameset.htm

Main idea is:

1. Register Functional Area in Workbook_SAP_Initialize() Sub.

2. Get information from Badi, using expression like: result = application.run("SAPListOf","CUSTOMAPPLCONTEXT")(3)

But how is it going to work if you want to get BADI result when openning workbook, and implement any logic there. For example, on the base of the BADI calculation I want either open or close workbook for editing (IP planning). If I try do do it in "AfterRedisplay Callback", I get nothing here: Application.Run("SAPListOf", "CUSTOMAPPLCONTEXT")(3). But after I open workbook and press refresh, the same method "AfterRedisplay Callback" starts, and now I get successfully the result of BADI.

How to make macro get BADI result just during openning the workbook?


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

0 Answers