Open SAP GUI automatically with Excel VBA and run Scripts (SAP GUI Scripting) [english]

preview_player
Показать описание
In today's video I show you how to open the SAP GUI automatically with the help of Excel VBA. I also pass the necessary login information to the SAP GUI, so that no more input is required from the user here.
Until now, the scripts could only be executed if the SAP GUI was already open and you had logged into the system.

#sap #sapgui #vba #excel #script

▬▬ Literature 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬

▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

*The links are affiliate links. There are no additional costs.

📍Attribution:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
Рекомендации по теме
Комментарии
Автор

Thank you very much, it still works for SAP 7.0.

zhimabukaimen
Автор

Like BDC tool :) Good to have it in excel too :)

balintka
Автор

Is there a way to get rid of the two pop ups that you pressed “ok” on. I’m looping through multiple servers so it’s annoying to keep pressing ok.

ilyas
Автор

Very well explained video! Thanks.
I get an error "Type mismatch: 'Shell' - Code: 800A000D", can you guess why? I've googled it and didn't get a solution.

CrisAndrades-foqz
Автор

Hi i just need a small help. Iam writing a python script for automatic my task. I found out iam not able to extract the values from tree hierarchies like i do for a normal findByIds. Is there a way where i can select the required data from hierarchies?

shilparamisetty
Автор

Do i need to have abap authorisation for it to use?

AmitKumar-csgx
Автор

Getting 614 error after opening opening sap logon through this code

TechMedia
Автор

Does anyone know how to logon to sap when SSO is being used?

gege
Автор

Great movie. That's exacly what I need. Onfortunatly when I try to open connection by Set connection = App.OpenConnecton("PROD", True) i get error :
Run-time error 438
Object desn't support this property or method

mariuszdekier