It works the same way as XL3DoWriteback but requires the current Anaplan value as an additional argument.
XL3DoWriteback2 should be used instead of XL3DoWriteback to write data back to Anaplan.
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 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 for example, "Measures" or "[Customer].[Customer Geography]" |
| Member1,…, MemberN | Either a single member unique name or an XL3Member formula |
