Difference between revisions of "Macros"

Latest revision as of 14:09, 8 May 2014

The following XLCubed 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 XLCubed formulae	All

@@ Line 1: / Line 1: @@
 The following XLCubed macros can be called from VBA:
+{| class="wikitable"
-*Application.Run "XL3RefreshGrid","Sheet1!a1"
+! Code
+! Description
-When using XL3RefreshGrid you need to include an address for the grid is to be refreshed, in Sheet1 at cell A1
+! Introduced
+|-
+| width="400" | {{Code|Application.Run "XL3RefreshGrid", "Sheet1!A1"}}
+| width="400" | Include an address for the Grid to be refreshed
-*Application.Run “XL3RefreshAllGrids”
+| v6.1
+|-
-You do not need to include an address when using XL3RefreshAllGrids.
+| {{Code|Application.Run "XL3RefreshAllGrids"}}
+| Refreshes all grids
+| v6.0
+|-
-*Application.CalculateFull
+| {{Code|Application.Run "XL3RefreshTable", "Sheet1!A1"}}
+| Include an address for the Table to be refreshed
-Use CalculateFull to force a calculate of XLCubed formulae.
+| v7.1
+|-
+| {{Code|Application.Run "XL3RefreshAllTables"}}
+| Refreshes all tables
+| v7.0
+|-
+| {{Code|Application.CalculateFull}}
+| Force a calculate of XLCubed formulae
+| All
+|}