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.

[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