You can call the Anaplan XL macros below from Visual Basic for Application (VBA).
| Code | Description |
Application.Run "XL3RefreshGrid", "Sheet1!A1" | Include an address for the grid to be refreshed. |
Application.Run "XL3RefreshAllGrids" | Refreshes all grids. |
Application.Run "XL3RefreshTable", "Sheet1!A1" | Include an address for the table to be refreshed. |
Application.Run "XL3RefreshAllTables" | Refreshes all tables. |
Application.CalculateFull | Force a calculation of Anaplan XL formulas. |
