Improve Customer Experience with MS Excel Visual Basic for Applications

489 results

  1. Improve Customer Experience with MS Excel Visual Basic for Applications

    Reading time: 12 mins

    By Dr. Marco Sisfontes-Monge, Managing Partner, Arellius Enterprises, Inc. There is a lot of material available to explain enhancements made to improve MS Excel Visual Basic for Applications (VBA) methods, procedures, and commands in order to create a better bridge between MS Excel and SAP Business Planning and Consolidation itself. Especially if you have coded…...…
  2. SAP NetWeaver BW and Xcelsius: Excel 2007 PivotTables Provide Enhanced Interactive Reporting and Analytics Options

    See how you can use Microsoft Excel 2007 PivotTables with SAP NetWeaver BW and Xcelsius to create a low-cost but highly functional reporting and analytics system. Learn how Xcelsius uses Excel 2007 as its data binding source for dynamic dashboards and data visualizations. Key Concept Microsoft completely redesigned Excel 2007 to be the company’s primary…...…
  3. The Office Document Toolbox for Creating RTF Documents and Spreadsheet Files Using ABAP: Part 2 — Reading and Writing Excel Documents

    As an alternative to using the COM interface (which can be cumbersome) for creating Microsoft Word and Excel files in ABAP, you can use the Office Document Toolbox, an open-source solution, to create word processing documents in Rich Text Format (RTF) and spreadsheets in Excel XLS format. Learn how to read and write Excel files…...…
  4. Experience the Next Level of Forecasting the Future Using Xcelsius Dashboard Applications

    Xcelsius dashboard applications present facts graphically, providing insight that helps in making business decisions. However, the future is uncertain and decisions should take that into account. Learn how Xcelsius can transform business facts into statistically valid probability models that give a more accurate view of the future using Monte Carlo simulation techniques. Sample code is…...…
  5. Link SAP Payslips to Your Excel Payroll Reports

    When you are viewing SAP payroll reports, they often make more sense when viewed side-by-side with employees’ payslips. This adds context and makes payroll reports much easier to understand. Learn a simple way to link payroll reports to employee payslips with short macros in Excel using Visual Basic for Applications (VBA). No ABAP code is…...…
  6. How to Pivot SAP BW Queries

    Although BW provides filter and drill-down functionality, many BW users miss the pivoting functionality of MS Excel. The author provides seven easy steps to enable drag-and-drop functionality in SAP BW queries. This gives end users the power to optimize their BW queries. I know from many talks with FI/CO end users who are running BW…...…
  7. Prevent Errors by Using Excel-Based Planning in CO

    Eliminate the manual entry step from the planning process in the SAP Controlling module by implementing a direct upload of your data using Microsoft Excel. This method prevents the errors that can occur when planning data is keyed into your SAP system manually. Key Concept You need to maintain planning data for cost objects in…...…
  8. Enhance a UI Pattern to Take Advantage of the New Excel Web Printing Functionality

    You now can enhance your user interface (UI) pattern to enable you to print your reports in Microsoft Excel using default print parameters. This solution permits users to specify their default print settings using the BI template wizard. When the Web template is generated, a button is added to the template and the default print…...…
  9. Create and Store Custom Excel Templates for Your SAP ERP HCM Reports

    Reading time: 14 mins

    ManagementMicrosoft Excel templates can be stored within your SAP system and assigned to reports and queries as part of the normal process of saving a variant. The standard SAP ERP HCM system already includes a document repository area called the Business Document Service (BDS). Custom Excel templates can easily be stored in the BDS using…...…
  10. How to Use Formula Mode for Complex Analysis

    Learn how to use an often-overlooked feature of the Excel-based reporting toolbox: formula mode. Learn why formula mode makes SAP BW’s BEx Analyzer and BusinessObjects Analysis the preferred tools for heavy analysis users. Key Concept Formula mode, a feature in BW’s BEx Analyzer and BusinessObjects Analysis for Excel, takes an SAP BW data stream and…...…