Video kann leider nicht angezeigt werden.
  • Start

    Using Excel, VBA and Charts



  • 1. Excel interface

    We start Excel via a JavaScript call and copy a GuiXT table variable



  • 2. Record a macro

    We record an Excel VBA macro for chart generation



  • 3. Call the Excel macro

    We call an Excel VBA macro from a GuiXT script



  • 4. Display the chart

    In the VBA macro we export the chart as .png file and display it



  • 5. Add a message

    During the chart generation we display a small message window



  • 6. Add drilldown

    We show the customer distribution within a country



  • Sample scripts

    Click here to download all project files as .zip archive