Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

Anyone here write a macro in Excel to kick off "Submit data"

Originally posted by Henning Windhagen

Hi All, did anyone here write a macro in Excel to kick off "Submit data"? A customer wants to enhance his data submission from Excel and was asking me about this.

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    Originally posted by Keith Berry

    Per KB0010071, these are the only functions supported:

  • kberry's avatar
    kberry
    New Contributor III

    An update for OneStream 6.6.0: triggering data submission of XFSetCells with an Excel macro is now possible. The new VBA function is 'SubmitSetXFFuntions'.

    • aneupane's avatar
      aneupane
      Contributor

      Thank you.

      Is this documented anywhere? Thanks.

  • kberry's avatar
    kberry
    New Contributor III

    Hi Anil - So far just on the 6.6.0 release notes.