CreateObject("SAP.BAPI.1") is not working with office365

[Mustafasaif]

I am using the below code for one of my macro which is connected with SAP , it post different transactions in SAP using a BAPI control.

The issue is that same code is working for all previous versions of excel and windows. but when we updated office to office365 and windows to windows10, it stops working and shows "429 ActiveX component can't create object" whereas when we use the same code in older version it is still working.

can anybody help me out in this regard.


*******VBA CODE*************
' create the BAPI ActiveX control and connect to SAP
Set oBAPICtrl = CreateObject("SAP.BAPI.1")


If oBAPICtrl.Connection.Logon(0, False) Then

' Goods movement object
Set oGoodsMovement = oBAPICtrl.getsapobject("GoodsMovement")

' commit work object
Set oBapiService = oBAPICtrl.getsapobject("BapiService")
Set oReturnCommit = oBAPICtrl.dimas(oBapiService, "TransactionCommit", "Return")
Set oGoodsmvtHeadret = oBAPICtrl.dimas(oGoodsMovement, "CreateFromData", "GoodsmvtHeadret")
Set oGoodsmvtItem = oBAPICtrl.dimas(oGoodsMovement, "CreateFromData", "GoodsmvtItem")
Set oGoodsmvtHeader = oBAPICtrl.dimas(oGoodsMovement, "CreateFromData", "GoodsmvtHeader")
Set oGoodsmvtCode = oBAPICtrl.dimas(oGoodsMovement, "CreateFromData", "GoodsmvtCode")


*******************************************

Thanks
Mustafa

[hrlngrv]

When you updated to Windows 10, did you reinstall your SAP client software?

Have you used REGEDIT to ensure there's a HKCR\SAP.BAPI.1 key? If you have, have you ensured that your version of the SAP client software works under Windows 10?

In any case, this is very likely more of a computer configuration problem than an Excel VBA problem. That being the case, SAP help forums may be better sources of information and advice than this forum.

[Mustafasaif]

Hi,

No! this is for sure Excel problem because it is happening not only on my system, it is happening on whatever system has windows10 and office365 irrespective of any SAP front end GUI.
whereas if I use the same excel file on any of older version of office , it is working fine there. Any Idea???

thanks
Mustafa

[hrlngrv]

The FIRST thing to check is whether the Windows 10 PCs with Office 365 have the registry key HKCR\SAP.BAPI.1. Whether you accept it or not, the most likely reason CreateObject fails is that there are problems in the registry key for [D]COM object you're trying to create. Thus best to eliminate that possibility first.

From a different perspective, your Windows 10 machines also have Windows Script Host/VBScript. You could confirm that this SAP object is working by using this VBScript file

test.vbs

Please Login or Register  to view this content.

Run this from a console command prompt as cscript test.vbs. If there's a systemic problem with that [D]COM object, you should see an error message like

E:\me\battest\test.vbs(3, 1) WScript.CreateObject: Could not locate automation class named "SAP.BAPI.1".

If you see something like that, the problem would be that the SAP BAPI control isn't properly installed.

This would be a configuration issue, and it's a dead certainty there are configuration differences between PCs running Windows 10 and Office 365 and other PCs running older versions of either Windows or Office.

If the VBScript file above doesn't display an error, then VBScript could create a SAP BAPI object, but Excel couldn't. At that point you would need to confirm that your version of that SAP control is compatible with Excel in Office 365.