Difference between revisions of "Macros"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | The following | + | The following FluenceXL macros can be called from VBA: |
{| class="wikitable" | {| class="wikitable" | ||
| Line 19: | Line 19: | ||
|- | |- | ||
| {{Code|Application.Run "XL3RefreshAllTables"}} | | {{Code|Application.Run "XL3RefreshAllTables"}} | ||
| − | | Refreshes all | + | | Refreshes all tables |
| v7.0 | | v7.0 | ||
|- | |- | ||
| {{Code|Application.CalculateFull}} | | {{Code|Application.CalculateFull}} | ||
| − | | Force a calculate of | + | | Force a calculate of FluenceXL formulae |
| All | | 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 |
