Skip to content

WriteBack (VBA)

Summary

There are a set of VBA functions that enable writeback.

  • StartWriteBack(Datasource, Catalog, MDX)
  • AddWriteBack(Row, Column, Value)
  • ExecuteWriteBack

These methods allow you to perform a bulk writeback operation to a cube at cell positions in the data grid specified by the MDX.

The data is not written until the ExecuteWriteBack method is called.

Example

With Application.COMAddIns("Calumo.ExcelClient.Connect").Object
    Call .StartWriteBack(DataSource, catalog, MDX)
    Call .AddWriteBack(1, 1, WritebackValue1)
    Call .AddWriteBack(2, 1, WritebackValue2)
    Call .AddWriteBack(3, 1, WritebackValue3)
    ErrorMessage = .ExecuteWriteback
End With