Log into SAP from Excel with SAP GUI Scripting API

Рет қаралды 4,847

ERP UP

Күн бұрын

Пікірлер: 40

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

Learn how to use the SAP GUI Scripting API

@AthmakuruNavyasree 9 ай бұрын

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

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

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

@talerguru2303 9 ай бұрын

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

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

More to come. Stay tuned :)

@sabinegeiger3442 9 ай бұрын

Thanks for the very good information !! 👍👍

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

Appreciated 👍

@annaz9630 9 ай бұрын

Thank you 👍

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

You're welcome 👍

@yuri2365 9 ай бұрын

Very helpful material!

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

Thank you very much for your support Yuri.

@klarazacher9725 9 ай бұрын

Sehr hilfreiche Vidios, wie immer. 😊

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

Danke für das Lob Klara 😊

@DHAMODHARANP-u9g 9 ай бұрын

Super bro

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

Thank you so much

@JosefZacher-k2z 9 ай бұрын

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

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

Спасибо 👍

@ethanwolfe1713 6 ай бұрын

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 6 ай бұрын

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.

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

👍

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

👍

@pdcm31 7 ай бұрын

Could you use this to mass create role for example?

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

You can also automate this, sure.

@cobraplays3230 Ай бұрын

How to get data from sheet1 Row A from excel to SAP and loop it in the macro

@ERP-UP Ай бұрын

First of all you can record a SAP GUI script if you enter the data manually. Then you have your template you can add your custom code. The code needs to be made in VBA. Have a closer look at these videos: SAP & Excel - 10 SAP GUI Scripting Tips 🚀 kzbin.info/www/bejne/oZzIYnyXo5mMhKM Install ABAP2XLSX - Create a professional Excel spreadsheet from ABAP kzbin.info/www/bejne/p3-pfI2ihsxob7c

@minhajulislam8230 4 ай бұрын

Getting Error 91. problem in the user id step.

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

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.

@paracordist10 6 ай бұрын

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

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

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

@manishsoni125 7 ай бұрын

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

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

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 6 ай бұрын

@@ERP-UP thanks a lot!!

@manishsoni125 7 ай бұрын

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

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

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 7 ай бұрын

@@ERP-UP got my mistake Thanks

@cryptoafc7655 9 ай бұрын

how safe it is?

@annaz9630 9 ай бұрын

Safe

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

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.