Submitting Excel form to Onestream using VBA

Hey all,

Since Onestream 6.6.0 there should be the option to trigger a Submit Workbook with VBA using SubmitSetXFFunctions. However, I can't get that to work. We're using Onestream 7.0 and the following VBA-code:

Sub SubmitWorkbookToOnestream()

  Set xfAddIn = Application.COMAddIns("OneStreamExcelAddIn")

  If Not xfAddIn Is Nothing Then

    If Not xfAddIn.Object Is Nothing Then
      Call xfAddIn.Object.SubmitSetXFFunctions
    End If

  End If

End Sub

If I run this I get an 'Object doesn't support this property or method' error. What am I doing wrong?