sap-training-courses

VBA Programming in SAP Analysis for Microsoft Office

Skills Gained This course will prepare you: To learn the foundations of Visual Basics for Applications (VBA) programming based on simple examples. To get to know specific Analysis VBA programming,...

Read More
$867 USD GSA  $741.76
Course Code BOAN15-v019
Duration 1 day
Available Formats Virtual, Classroom
5784 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

Skills Gained

  • This course will prepare you:
  • To learn the foundations of Visual Basics for Applications (VBA) programming based on simple examples.
  • To get to know specific Analysis VBA programming, based on practice- oriented tasks and exercises

Who Can Benefit

  • Application Consultant
  • Developer Consultant

Prerequisites

  • Essential:
  • BOAN10 Recommended:
  • None

Course Details

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
Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward