Question Re: SAP GUI Scripting API for 64 bit Office (VBA) in Technology Q&A

SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Fri, 22 Feb 2019 15:22:47 GMT

We're trying to make a SAP Scripting add-in for 64bit Office but we've had no success so far.

Would anyone know if this is feasible? Any help is highly appreaciated.

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Sat, 23 Feb 2019 08:07:39 GMT

Hello Caitlin,

it is possible to use SAP GUI Scripting with 64-bit applications, also Microsoft Office VBA.

Here an example:

If I remember it right, older versions of the SAP GUI for Windows did not offer this possibility. Which version of SAP GUI for Windows do you use? If it is an older version, update to the actual release.

Best regards
Stefan

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Sat, 23 Feb 2019 10:26:29 GMT

Hello Stefan!

We’re using SAP 7.5 patch level 2

Would you know the requirements of SAP Scripting for 64 bit Office? (Example. SAP Version, Patch Level)

Thank you

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Sat, 23 Feb 2019 17:54:42 GMT

Hello Caitlin,

sure, let us know your requirements, on this way we can help you.

Best regards
Stefan

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Mon, 25 Feb 2019 16:07:33 GMT

Would this work with SAP 7.5 Patch level 2?

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Tue, 26 Feb 2019 07:08:02 GMT

Hello Caitlin,
in a normal case I would say yes, but I don't know it definitely because I don't have this environment anymore to check it.

Best regards
Stefan

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Tue, 26 Feb 2019 09:29:18 GMT

In that case we've already tried. with no success. what version are you using?

with our ribbon add-in we are also getting several error messages

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Tue, 26 Feb 2019 09:36:08 GMT

Hello Caitlin,
I tried it with SAP GUI for Windows 7.50 PL 7.

Best regards
Stefan

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Tue, 26 Feb 2019 11:02:15 GMT

We're currently getting this error

We can't identify the cause of the issue.

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Tue, 26 Feb 2019 12:28:49 GMT

How do you get this error? Do you execute the script from above? Does the ST22 show any further information?

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Tue, 26 Feb 2019 13:00:18 GMT

When we logon on the sap gui window under excel. after entering our credentials we get this error.

We're not authorized to use st22

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Tue, 26 Feb 2019 15:26:52 GMT

You mean you do that...

'-Begin-----------------------------------------------------------------

'-Directives------------------------------------------------------------
Option Explicit

'-Sub Main--------------------------------------------------------------
Sub Main()

  '-Variables-----------------------------------------------------------
  Dim SapGuiAuto As Object
  Dim SapApp As SAPFEWSELib.GuiApplication
  Dim connection As SAPFEWSELib.GuiConnection
  Dim session As SAPFEWSELib.GuiSession

  Set SapGuiAuto = GetObject("SAPGUI")
  If Not IsObject(SapGuiAuto) Then
    Exit Sub
  End If

  Set SapApp = SapGuiAuto.GetScriptingEngine
  If Not IsObject(SapApp) Then
    Exit Sub
  End If

  Set connection = SapApp.Children(2)
  If Not IsObject(connection) Then
    Exit Sub
  End If

  Set session = connection.Children(0)
  If Not IsObject(session) Then
    Exit Sub
  End If

  session.findById("wnd[0]/usr/txtRSYST-MANDT").Text = "001"
  session.findById("wnd[0]/usr/txtRSYST-BNAME").Text = "BCUSER"
  session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text = "minisap"
  session.findById("wnd[0]/usr/txtRSYST-LANGU").Text = "DE"
  session.findById("wnd[0]").sendVKey 0

End Sub

'-End-------------------------------------------------------------------

... and with the execution of sendVKey 0 you get an ABAP error but if you do the same steps manually it works with the same credentials?

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Former Member — Fri, 01 Mar 2019 16:40:46 GMT

if these codes are in a excel sheet. vbscript wont working

  session.findById("wnd[0]/usr/txtRSYST-BNAME").Text = "BCUSER"
  session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text = "minisap"
  session.findById("wnd[0]/usr/txtRSYST-LANGU").Text = "DE"

example:

how would we run this on vba?

Re: SAP GUI Scripting API for 64 bit Office (VBA)

Stefan-Schnell — Tue, 05 Mar 2019 06:35:44 GMT

Hello Caitlin,

sure, it can't work.

BNAME = your user name, BCUSER is a standard user
BCODE = your password, minisap is a the standard for BCUSER
LANGU = your language code, e.g. EN, DE is for Germany systems

Try it with

session.findById("wnd[0]/usr/txtRSYST-BNAME").Text = "caitlin" 'Here your user name
session.findById("wnd[0]/usr/pwdRSYST-BCODE").Text = "secret" 'Here your password
session.findById("wnd[0]/usr/txtRSYST-LANGU").Text = "EN" 'Here your language code

Best regards
Stefan