VBA Programming in SAP Analysis for Microsoft Office

Course Content

• Introduction to VBA Programming in SAP Analysis for Microsoft Office
• VBA Basics
     -Outlining Visual Basic for Applications
     -Using Objects, Methods, and Properties
     -Using Variables
     -Explainng Debugging Mode
• Prepare a Workbook for Business Users
     -Showing the Prompt Dialog Using a Macro
     -Showing and Hiding Analysis UI Comonents
     -Saving Analysis Workbooks with Macros
• Change Filters and Variables via Macros
     -Filtering your Analysis Data Source
     -Understanding Conditional Statements
     -Working with Messages
     -Using ActiveX Controls in your Workbook
     -Explaining Loop Programming
     -Explaining Array Programming
     -Changing a Variable Value
• Use Context Senstive Information
     -Obtaining Analysis Specific Information for a Cell
     -Calling the Member Selector Using VBA
     -Using Double Click for Navigation
• Tips and Tricks

Notes

• This course is designed for an audience which has no or little knowledge of VBA.

Course based on software release

• SAP BusinessObjects BI 4.3
• SAP Analysis for Microsoft Office 2.8