Log into SAP from Excel with SAP GUI Scripting API

Рет қаралды 1,336

Күн бұрын

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! 🙌
/ @erp-up
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🎬 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:
German Blog: erp-up.de/blog/
My book recommendations: erp-up.de/book-recommendation...
"100 Tips and Tricks in SAP ERP" course on Udemy: www.udemy.com/course/100-tips...
🙏 Support ERP UP:
Subscribe: / @erp-up
Support ERP UP directly: erp-up.de/support-erp-up/
Support ERP UP via Amazon: amzn.to/3f40uSG
PayPal Donation: www.paypal.com/paypalme/andre...
🔗 Connect with Andreas Geiger:
LinkedIn: / andreas-geiger
Xing: www.xing.com/profile/Andreas_...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Feel free to engage with the content and support the channel through the provided links. Your support is greatly appreciated! 🌟

Пікірлер: 33

@ERP-UP 2 ай бұрын

Learn how to use the SAP GUI Scripting API

@user-qq7cc1pe4v 2 ай бұрын

Super bro

@ERP-UP 2 ай бұрын

Thank you so much

@sabinegeiger3442 2 ай бұрын

Thanks for the very good information !! 👍👍

@ERP-UP 2 ай бұрын

Appreciated 👍

@annaz9630 2 ай бұрын

Thank you 👍

@ERP-UP 2 ай бұрын

You're welcome 👍

@Baba11-ex1zl 2 ай бұрын

👍

@ERP-UP 2 ай бұрын

👍

@talerguru2303 2 ай бұрын

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

@ERP-UP 2 ай бұрын

More to come. Stay tuned :)

@yuriniazov8376 2 ай бұрын

Very helpful material!

@ERP-UP 2 ай бұрын

Thank you very much for your support Yuri.

@user-wf7ju6li7e 2 ай бұрын

Спасибо за информацию👍

@ERP-UP 2 ай бұрын

Спасибо 👍

@klarazacher9725 2 ай бұрын

Sehr hilfreiche Vidios, wie immer. 😊

@ERP-UP 2 ай бұрын

Danke für das Lob Klara 😊

@AthmakuruNavyasree 2 ай бұрын

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

@ERP-UP 2 ай бұрын

Thank you so much for your nice comment and the praise. I appreciate that :)

@paracordist10 13 күн бұрын

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

@pdcm31 Ай бұрын

Could you use this to mass create role for example?

@ERP-UP Ай бұрын

You can also automate this, sure.

@manishsoni125 25 күн бұрын

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

@ERP-UP 23 күн бұрын

Have a closer look the "Programming API" available under "SAP GUI Scripting" at service.sap.com/sapgui. The GuiApplication object has an ActiveSession property that points to the session the user is currently working in, which is the topmost window. This should work: Set session = application.ActiveSession

@manishsoni125 5 күн бұрын

@@ERP-UP thanks a lot!!

@manishsoni125 26 күн бұрын

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

@ERP-UP 25 күн бұрын

The runtime error 619 is "Control Could Not Be Found by ID". Check if you are using the correct ID. Debugging can also help to identify the error or the exact line where the error occurs. Have a closer look: kzfaq.info/get/bejne/odGVZKyS05q9fnU.htmlsi=poy3yUcwgJHc9RxF&t=1355

@manishsoni125 25 күн бұрын

@@ERP-UP got my mistake Thanks

@cryptoafc7655 2 ай бұрын

how safe it is?

@annaz9630 2 ай бұрын

Safe

@ERP-UP 2 ай бұрын

It depends how you define "safe". The password is saved in clear text in the example. There are also some possibilities to save it not in clear text within excel to use VBA. You can also protect the whole excel file if you want to. In general I wanted to set the focus in the SAP GUI Scripting API.