Question Re: Accessing SAP using Excel VBA - Invalid Syntax Error in Technology Q&A

Accessing SAP using Excel VBA - Invalid Syntax Error

Former Member — Tue, 08 Dec 2020 17:50:49 GMT

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.

Re: Accessing SAP using Excel VBA - Invalid Syntax Error

Sandra_Rossi — Tue, 08 Dec 2020 20:26:40 GMT

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

Re: Accessing SAP using Excel VBA - Invalid Syntax Error

Former Member — Wed, 09 Dec 2020 14:36:08 GMT

Hi Sandra,

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

Re: Accessing SAP using Excel VBA - Invalid Syntax Error

Stefan-Schnell — Sat, 12 Dec 2020 07:43:13 GMT

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.

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

Best regards
Stefan

Re: Accessing SAP using Excel VBA - Invalid Syntax Error

nachodrums — Mon, 13 Nov 2023 14:28:28 GMT

Hello.

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