SAP Logon connection with VBA automation error

Asked Apr 12 '18 at 09:42

Active Jun 21 '23 at 15:52

Viewed 2,045 times

I have the following code for connecting SAP logon with VBA

Private Sub CommandButton1_Click()
Dim SAPapplication, Connection, session As Object
Set SAPGUIAuto = GetObject("SAPGUI")

Set SAPapplication = SAPGUIAuto.GetScriptingEngine
Set Connection = SAPapplication.Children(0)

Set session = Connection.Children(0)

session.findById("wnd[0]").maximize
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/tbar[0]/okcd").Text = "******"
session.findById("wnd[0]").sendVKey 0

The code works perfectly if I have login through my credentials in the SAP system. But it gives following error, when I try login through other credentials.

Run-time error '-2147221020 (800401e4)':

Automation error
Invalid syntax

What is the problem here?

edited Jun 21 '23 at 15:52

Sandra Rossi

11,934
5
22
48

asked Apr 12 '18 at 09:42

urvashi

For this code to work the pre-requsite is a running SAP session – Storax Apr 12 '18 at 10:19
yes the SAP session is already open when i am starting to run the code – urvashi Apr 12 '18 at 10:21
What should one imagine under other credentials? – ScriptMan Apr 12 '18 at 12:29
At which line does the error occur? I assume `Set SAPGUIAuto = GetObject("SAPGUI")`. If yes then SAPLOGON is not started and you do not have a running SAP session – Storax Apr 12 '18 at 12:41
@Storax : i do have session open and yes i am facing error at the line you have mentioned – urvashi Apr 12 '18 at 13:27
That can't be unless the session is not local and you connect via a terminal server to SapGui – Storax Apr 12 '18 at 15:46

SAP Logon connection with VBA automation error

0 Answers0