Working with macros
Analysis contains API methods that can be used in VBA macros that are embedded in
Microsoft Office Excel workbooks. Macros are created in the Visual Basic Editor. The
Visual Basic Editor can be used to write and edit a macro that is attached to a
Microsoft Office Excel workbook. The macros can be connected to UI elements that are
available on the Developer tab in the menu.
Note In Microsoft
Excel 2003, you can find the UI elements in the Forms
toolbar.
You can also use the Analysis functions for creating formulas in VBA macros.
Microsoft Office documentation provides information about creating and using VBA macros. The following section describes the Analysis API methods.
The following methods are available in
Analysis:
- SAPAddMessage
- SAPCallMemberSelector
- SAPExecuteCommand
- SAPExecutePlanningFunction
- SAPExecutePlanningSequence
- SAPGetCellInfo
- SAPGetProperty
- SAPLogon
- SAPMoveDimension
- SAPSetFilter
- SAPSetPlanParameter
- SAPSetRefreshBehaviour
- SAPSetVariable