Log into SAP from Excel with SAP GUI Scripting API

Learn how to enable the SAP GUI Scripting API in Excel. I will also provide and explain a VBA code to automatically log into SAP from Excel.

👍 Don't forget to like, comment, and subscribe to support the channel! Thank you for your incredible support! 🙌

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👨‍💻 VBS Code:
Sub SAPLogin()

Dim SapGui As Object
Dim App As SAPFEWSELib.GuiApplication
Dim Conn As SAPFEWSELib.GuiConnection
Dim Session As SAPFEWSELib.GuiSession

Set SapGui = GetObject("SAPGUI")
If IsObject(SapGui) Then
Set App = SapGui.GetScriptingEngine
If IsObject(App) Then
Set Conn = App.OpenConnection("ABAP Platform 1909 Trial")
If IsObject(Conn) Then
Set Session = Conn.Children(0)
Session.FindById("wnd[0]/usr/txtRSYST-MANDT").Text = "001"
Session.FindById("wnd[0]/usr/txtRSYST-BNAME").Text = "DEVELOPER"
Session.FindById("wnd[0]/usr/pwdRSYST-BCODE").Text = "Htods70334"
Session.FindById("wnd[0]/usr/txtRSYST-LANGU").Text = "EN"
Session.FindById("wnd[0]").SendVKey 0
Session.StartTransaction ("SE16")
End If
End If
End If

End Sub
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🎬 Content Timestamps:
00:00 - Intro
01:14 - Activate Developer ribbon
02:00 - Include SAP GUI Scripting API
04:05 - VBA to SAP Login from Excel
08:02 - Insert form control
08:23 - Excel to SAP Login
08:45 - Outro

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🎵 Music Credits:

"Oh My" by Patrick Patrikios
"Feels" by Patrick Patrikios

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

🔗 Useful Links:

🙏 Support ERP UP:

🔗 Connect with Andreas Geiger:

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Feel free to engage with the content and support the channel through the provided links. Your support is greatly appreciated! 🌟

[ERP-UP]

Learn how to use the SAP GUI Scripting API

[sabinegeiger]

Thanks for the very good information !! 👍👍

[talerguru]

Well done. Very helpful. Please more on SAP GUI Scripting.

[AthmakuruNavyasree]

I diligently watch and learn from each instructional video that you provide, Great Content!. It really helps. Thank you Very Much :)

[ethanwolfe]

This is super helpful! Is there documentation anywhere that details the available methods and properties for these SAP objects being used in VBA? This video is the only place I can find the "Application.OpenConnection" method being used. It was exactly what I needed but I couldn't find a list of available methods or functions anywhere online.

[pdcm]

Could you use this to mass create role for example?

[paracordist]

Could you please provide the code in the description as well?

[manishsoni]

Unable to login when multiple window of Sap gui is open please help on this

[hk]

Cannot find SAP GUI Scripting API . How to add？

[manishsoni]

Sap is opening but not getting logged in runtime error 619 coming