XL3DoWriteback2
XL3DoWriteback2 should be used instead of XL3DoWriteback to write data back to Anaplan. It only takes one the additional "InitialValue" argument.
Please refer to XL3DoWriteback for more details.
Syntax
XL3DoWriteback2( PerformWriteback, IntitialValue, WriteValue, Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| 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 |
| IntitialValue | The current value stored in Anaplan for that cell. Typically this is read from an AnaplanXL grid. |
| 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 |
