Log into SAP from Excel with SAP GUI Scripting API

Подписаться 4,6 тыс.

Просмотров 1,6 тыс.

50% 1

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! 🌟

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 35

@ERP-UP 3 месяца назад

Learn how to use the SAP GUI Scripting API

@talerguru2303 3 месяца назад

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

@ERP-UP 3 месяца назад

More to come. Stay tuned :)

@user-qq7cc1pe4v 3 месяца назад

Super bro

@ERP-UP 3 месяца назад

Thank you so much

@sabinegeiger3442 3 месяца назад

Thanks for the very good information !! 👍👍

@ERP-UP 3 месяца назад

Appreciated 👍

@user-wf7ju6li7e 3 месяца назад

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

@ERP-UP 3 месяца назад

Спасибо 👍

@yuri2365 3 месяца назад

Very helpful material!

@ERP-UP 3 месяца назад

Thank you very much for your support Yuri.

@AthmakuruNavyasree 3 месяца назад

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

@ERP-UP 3 месяца назад

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

@Baba11-ex1zl 3 месяца назад

👍

@ERP-UP 3 месяца назад

👍

@annaz9630 3 месяца назад

Thank you 👍

@ERP-UP 3 месяца назад

You're welcome 👍

@klarazacher9725 3 месяца назад

Sehr hilfreiche Vidios, wie immer. 😊

@ERP-UP 3 месяца назад

Danke für das Lob Klara 😊

@ethanwolfe1713 5 дней назад

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.

@ERP-UP 2 дня назад

Thank you. Unfortunately, I also don't have any official documentation for developers about SAP GUI Scripting. I record the steps in SAP GUI and analyze the generated VBS code. Within the SAP GUI under "Customize Local Layout > SAP GUI Scripting Help" you get access to the SAP GUI Scripting API.

@paracordist10 28 дней назад

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 Месяц назад

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

@ERP-UP Месяц назад

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 20 дней назад

@@ERP-UP thanks a lot!!

@manishsoni125 Месяц назад

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

@ERP-UP Месяц назад

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kke1Ian4YNA.htmlsi=poy3yUcwgJHc9RxF&t=1355

@manishsoni125 Месяц назад

@@ERP-UP got my mistake Thanks

@281173hk Месяц назад

Cannot find SAP GUI Scripting API . How to add？

@ERP-UP Месяц назад

Have a closer look at 02:00 - Include SAP GUI Scripting API

@cryptoafc7655 3 месяца назад

how safe it is?

@annaz9630 3 месяца назад

Safe

@ERP-UP 3 месяца назад

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.