Difference between revisions of "Macros"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | The following FluenceXL macros can be called from VBA: | |
| − | The following | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | | width=" | + | ! Code |
| − | | width="400" | Include an address for the | + | ! Description |
| + | ! Introduced | ||
| + | |- | ||
| + | | width="400" | {{Code|Application.Run "XL3RefreshGrid", "Sheet1!A1"}} | ||
| + | | width="400" | Include an address for the Grid to be refreshed | ||
| + | | v6.1 | ||
|- | |- | ||
| − | | | + | | {{Code|Application.Run "XL3RefreshAllGrids"}} |
| Refreshes all grids | | Refreshes all grids | ||
| + | | v6.0 | ||
| + | |- | ||
| + | | {{Code|Application.Run "XL3RefreshTable", "Sheet1!A1"}} | ||
| + | | Include an address for the Table to be refreshed | ||
| + | | v7.1 | ||
| + | |- | ||
| + | | {{Code|Application.Run "XL3RefreshAllTables"}} | ||
| + | | Refreshes all tables | ||
| + | | v7.0 | ||
|- | |- | ||
| − | | | + | | {{Code|Application.CalculateFull}} |
| − | | Force a calculate of | + | | Force a calculate of FluenceXL formulae |
| + | | All | ||
|} | |} | ||
Latest revision as of 09:01, 4 July 2023
The following FluenceXL macros can be called from VBA:
| Code | Description | Introduced |
|---|---|---|
| Application.Run "XL3RefreshGrid", "Sheet1!A1" | Include an address for the Grid to be refreshed | v6.1 |
| Application.Run "XL3RefreshAllGrids" | Refreshes all grids | v6.0 |
| Application.Run "XL3RefreshTable", "Sheet1!A1" | Include an address for the Table to be refreshed | v7.1 |
| Application.Run "XL3RefreshAllTables" | Refreshes all tables | v7.0 |
| Application.CalculateFull | Force a calculate of FluenceXL formulae | All |
