Accessing SAP using Excel VBA - Invalid Syntax Error

[Former Member]

Hello,

We want to run SAP Script from Excel VBA programming. We are getting error message while executing scripts at following line of code:

SAP Version: 7.6

Excel Version: 365 Pro Plus

If objGui Is Nothing Then

Set SapGuiAuto = GetObject("SAPGUI")

Set objGui = SapGuiAuto.GetScriptingEngine

End If

Error Message:

VBA References added :

Please suggest how to resolve this issue.

[Sandra_Rossi]

I guess you tried to paste a screenshot of the error, but it failed, nothing is shown.

[Stefan-Schnell]

Hello Parvez,

the error 800401e4 means that you can't get the object from the running object table (ROT). Be sure that your SAP Logon is open, that SAP GUI Scripting is installed and activated, on the client and server side.

• Enable Scripting on Client Side
• Enable Scripting on Server Side

If all these conditions apply, you should also get the object from the ROT.

Best regards
Stefan

[Former Member]

Hi Sandra,

Thanks for response. Pls find attached error screenshot and reference added to Excel.

[nachodrums]

Hello.

What happens if I don't have SAP GUI Scripting API or SessionMsgLib? I am running on Citrix Reciever App