Difference between revisions of "XL3DoWriteback2"

Revision as of 15:35, 30 October 2024

XL3DoWriteback2 works similary to XL3DoWriteback but is used instead to input data to Anaplan and takes the additional "InitialValue" argument.

XL3DoWriteback2( PerformWriteback, IntitialValue, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )

Parameter	Description
`PerformWriteback`	A reference to a range containing a boolean value (`TRUE` or `FALSE`) specifying whether to actually perform the writeback. That cell's value will be reset to `FALSE` following the writeback operation
`WriteValue`	The value to be written. Typically an Excel cell reference.
`Connection`	Connection number to use
`Hierarchy1,…, HierarchyN`	Name of the hierarchy that the following member applies to e.g. `"Measures"` or `"[Customer].[Customer Geography]"`
`Member1,…, MemberN`	Either a single member unique name or an XL3Member formula

@@ Line 1: / Line 1: @@
-XL3DoWriteback2 works similary to [[XL3DoWriteback]] and can be used to input data to Anaplan.
+XL3DoWriteback2 works similary to [[XL3DoWriteback]] but is used instead to input data to Anaplan and takes the additional "InitialValue" argument.
+==Syntax==
+{{Code|XL3DoWriteback2( PerformWriteback, IntitialValue, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )}}
+==Parameters==
+{| class="wikitable"
+! Parameter
+! Description
+|-
+| {{Code|PerformWriteback}}
+| A reference to a range containing a boolean value ({{TRUE}} or {{FALSE}}) specifying whether to actually perform the writeback. That cell's value will be reset to {{FALSE}} following the writeback operation
+|-
+| {{Code|WriteValue}}
+| The value to be written. Typically an Excel cell reference.
+|-
+| {{Code|Connection}}
+| Connection number to use
+{{Standard_HierarchyMember_List}}
+|}