Submitting Excel form to Onestream using VBA

pvanerp
New Contributor

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?

1 ACCEPTED SOLUTION

JackLacava
Community Manager
Community Manager

Sorry, that was a typo in Release Notes. The actual function is called SubmitXFFunctions, if you search for it in online help you'll also get a working example.

View solution in original post

1 REPLY 1

JackLacava
Community Manager
Community Manager

Sorry, that was a typo in Release Notes. The actual function is called SubmitXFFunctions, if you search for it in online help you'll also get a working example.