Microsoft Visual Basic for Applications (VBA) can be used to extend the features and functions provided by the SAP Integrated Business Planning, add-in for Microsoft Excel.
As a first step during the VBA code implementation, it is necessary to get the SAP IBP automation object.
The variable for the SAP IBP automation object must be declared as an object data type in the VBA coding.
The SAP IBP automation object enables the calling of the available SAP IBP APIs (Advanced Programming Interface).
To make the use of custom VBA coding in combination with the SAP IBP, add-in for Microsoft Excel easier, several extensibility capabilities are provided:
- SAP IBP APIs (VBA methods)
- SAP IBP APIs are used to enhance your planning view templates, build your own business logic, and automate manual steps.
- SAP IBP Hooks (VBA Events)
- SAP IBP hooks can be used to react to specific events triggered through actions in the Microsoft Excel add-in.
- SAP IBP ribbon extension
- The SAP IBP ribbon of the Microsoft Excel add-in can be extended with additional Visual Basic Editor or VBA functions.
- VBA samples
- VBA samples provide an idea of the capabilities of custom VBA coding in the Microsoft Excel add-in.