Difference between revisions of "Macros"

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

@@ Line 1: / Line 1: @@
-The following XLCubed macros can be called from VBA:
+The following FluenceXL macros can be called from VBA:
-*Application.Run "XL3RefreshGrid","Sheet1!a1"
+{| class="wikitable"
+! Code
-As you can see in the example you need to include an address for the grid is to be refreshed.
+! Description
+! Introduced
-*Application.Run “XL3RefreshAllGrids”
+|-
+| width="400" | {{Code|Application.Run "XL3RefreshGrid", "Sheet1!A1"}}
-You do not need to include an address when using XL3RefreshAllGrids.
+| width="400" | Include an address for the Grid to be refreshed
+| v6.1
-*Application.CalculateFull
+|-
+| {{Code|Application.Run "XL3RefreshAllGrids"}}
-Use CalculateFull to force a calculate of XLCubed formulae.
+| 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 FluenceXL formulae
+| All
+|}