-
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
