CODEWITHSUNDEEP
excelvbavbscriptsap-guisaprfc
Tom McDonald
Tom McDonald

Reputation: 1902

Error 429 Excel VBA activex CreateObject(“SAP.Functions”)

I just upgraded to Windows 10 and Excel 2016 and now my VBA app doesn't work:

set x = CreateObject("SAP.Functions")

I get this error:

runtime error 429 ActiveX component can’t create object

Upvotes: 0

Views: 4380

Answers (1)

Tom McDonald
Tom McDonald

Reputation: 1902

The solution was to install Office 32-bit version. For some reason the 64-bit Office doesn't support the "SAP.Functions" even though the SAP DLLs and OCXs were correctly installed and registered.

Upvotes: 0

Related Questions