Log into SAP from Excel with SAP GUI Scripting API

[@sabinegeiger3442]

Thanks for the very good information !! 👍👍

[@ERP-UP]

Appreciated 👍

[@talerguru2303]

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

[@ERP-UP]

More to come. Stay tuned :)

[@AthmakuruNavyasree]

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

[@ERP-UP]

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

[@klarazacher9725]

Sehr hilfreiche Vidios, wie immer. 😊

[@ERP-UP]

Danke für das Lob Klara 😊

[@annaz9630]

Thank you 👍

[@ERP-UP]

You're welcome 👍

[@ERP-UP]

Learn how to use the SAP GUI Scripting API

[@yuri2365]

Very helpful material!

[@ERP-UP]

Thank you very much for your support Yuri.

[@JosefZacher-k2z]

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

[@ERP-UP]

Спасибо 👍

[@DHAMODHARANP-u9g]

Super bro

[@ERP-UP]

Thank you so much

[@Baba11-ex1zl]

👍

[@ERP-UP]

👍

[@ethanwolfe1713]

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]

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.

[@pdcm31]

Could you use this to mass create role for example?

[@ERP-UP]

You can also automate this, sure.

[@paracordist10]

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

[@ERP-UP]

Sure, I have added the VBS code in the video description.

[@minhajulislam8230]

Getting Error 91. problem in the user id step.

[@ERP-UP]

Without seeing your code and without knowing what kind of code you are trying to use it is difficult to find the root cause. Check your coding once again and compare it with the code used in the video. Check if there are any typos. You can also debug to see exactly what line / statement causes the error. It seems you are having an problem with creating an object variable. There are two steps to creating an object variable. First you must declare the object variable. Then you must assign a valid reference to the object variable using the Set statement. You attempted to use an object variable that has been set to Nothing.

[@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]

@@ERP-UP thanks a lot!!

[@cryptoafc7655]

how safe it is?

[@annaz9630]

Safe

[@ERP-UP]

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.

[@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: kzbin.info/www/bejne/oZzIYnyXo5mMhKMsi=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