Excel connection to SAP failed after GUI 8.00 Update

[luis23huang]

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")

[anne-petteroe]

Hello Luis,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,
Anne

[alexanderjacob]

I there a solution for this problem?

[mamartins]

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]

I have the latest SAP GUI 8 PL installed (currently PL6).

[alexanderjacob]

I'm getting the exact same VBA runtime error, when I try to use CreateObject("SAP.Functions.UNICODE") out of an Excel macro.