cancel
Showing results for 
Search instead for 
Did you mean: 

Excel connection to SAP failed after GUI 8.00 Update

luis23huang
Discoverer
0 Kudos
1,736

After update to GUI 8.00 - Excel macros with VBA failed

VBA Run Time Error -2147221164(80040154) Class Not Registered

Set objSAPlogin = CreateObject("SAP.Functions")

Accepted Solutions (0)

Answers (2)

Answers (2)

mamartins
Active Contributor
0 Kudos

Perhaps some component was missing during the installation or the ADDON is not active...
https://answers.microsoft.com/en-us/msoffice/forum/all/activating-an-inactive-excel-add-in/a8af5ad0-...

mamartins
Active Contributor
0 Kudos

Do you have the latest SAP GUI 8.00 update/PL installed?

SAP GUI 8 have a 32 and 64 bit versions. OFFICE have x64 for a long time. They should match for the plugins to work. 

alexanderjacob
Discoverer
0 Kudos
I have the latest SAP GUI 8 PL installed (currently PL6).
alexanderjacob
Discoverer
0 Kudos
I'm getting the exact same VBA runtime error, when I try to use CreateObject("SAP.Functions.UNICODE") out of an Excel macro.
marioschultz
Newcomer
0 Kudos
Hi, I am getting the same error. Since upgrading to SAP GUI 8 in 64bit (Office is on 64bit already) the macros are failing with above mentioned error message. I have alreay added wdtaocx.ocx to the references in VBA, but this has not solved the issue. Is there any update on how to fix this?