VB Error 8814 - Method not found - in VBA of Excel spreadsheet

[Former Member]

I have the following code:

Dim oBAPICtrl As Object

Dim oConn As Object

Dim boOrder As Object

Dim oHeader As Object

Set oBAPICtrl = CreateObject("SAP.BAPI.1")

Set oConn = oBAPICtrl.Connection

oConn.user = "xxxxxxxx"

oConn.client = "999"

oConn.Logon

Set boOrder = oBAPICtrl.GetSAPObject("SalesOrder")

Set oHeader = oBAPICtrl.DimAs(boOrder, "CreateFromDat2", "OrderPartners") <---- and I get the 8814 error here

....

....

Set boOrder = Nothing

oConn.Logoff

Set oBAPICtrl = Nothing

What is causing this error? Please note that I have NOT added a reference to the SAP BAPI control - as I do not see it as an option in the list - is this issue? Please note though that the "Set boOrder = ..." does not return an error.

As well, oConn.IsConnected = 1 (true) when I check in the Immedidate Window.

Error message reads: "Run-time error 8814 - CreateFromDat2 is not a BAPI method." However, I see the BAPI method in the SAP BOR.

Please help. Thanks.

[Former Member]

I should that a Trace on the BAPI (RFC) call had this line at the top of the Trace:

"BackEnd Release WITHOUT BAPI support"

Can Basis Setings turn off the calling of BAPIs from outside of SAP itself?