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

Подписаться 10 тыс.

Просмотров 10 тыс.

50% 1

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
✅ Book, I am currently reading: amzn.to/43Zat2C
▬▬ Literature 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬
▶ ABAP: An Introduction 2020 amzn.to/45CLTqk
▶ Complete ABAP 2023 amzn.to/45D5UNM
▶ ABAP to the Future 2022 amzn.to/42cgWGs
▶ Clean ABAP 2022 amzn.to/3KAqmow
▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬
▶ Microphone: amzn.to/3zj2UIz
▶ Headphone: amzn.to/3GUBRFg
▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬
▶ Video Recorder: bit.ly/678fgh6
▶ Video Editor: bit.ly/38Rj9lb
▶ Thumbnail: bit.ly/CustAnd...
▶ Gamma AI: bit.ly/3nsdvgr
▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐Become my subscriber: bit.ly/CustAnd...
🎬All videos in English: bit.ly/CustAnd...
☕Buy me a Coffee 😀: bit.ly/3dih2cl
*The links are affiliate links. There are no additional costs.
📍Attribution:
Icons from: icon-icons.com RU-vid Subscribe Animations: pixabay.com/vi...
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
RU-vid Subscribe Animations: pixabay.com/vi...

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

11 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@zhimabukaimen 6 месяцев назад

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

@CustAndCode 6 месяцев назад

Thanks for your feedback! 🤗😀 I apprechiate it!

@sajidm2121 29 дней назад

How to add if context to open sap.exe only if it’s not currently on.

@balintka25 Год назад

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

@CustAndCode Год назад

Yes 🤗 For some reasons it is really handy to have this in excel. 😀

@ilyas9818 Год назад

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.

@CustAndCode Год назад

Sure, just go in the SAP GUI Options --> Folder: Accesability & Scripting --> Scripting --> uncheck the checkboxes: Notify when a script attaches to SAP GUI Notify when a script opens a connection 🤗

@shilparamisetty7307 7 месяцев назад

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?

@CustAndCode 7 месяцев назад

Automate things in SAP with Python, sounds very interesting! 😀 Regarding your question, I have not used any trees in SAP or in my program to date. So unfortunately I can't help you here. But I find your idea of using Python interesting! 🤗

@CustAndCode 7 месяцев назад

Maybe you can try this tool: tracker.stschnell.de/ 🤗

@CrisAndrades-fo4qz 9 месяцев назад

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.

@CustAndCode 8 месяцев назад

Maybe something is null or empty which is not allowed. But I don't know exactly. 🤔

@AmitKumar-cs2gx 2 месяца назад

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

@CustAndCode 2 месяца назад

We do not use ABAP here. You only need the right to call the transaction se16 (for this example) 🤗

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

Depending on your SAP deployment you may need SAP GUI scripting enabled on your PC. In my company it is disabled by default for all users. You IT side SAP Admin should be able to help there.

@TechMedia41 9 месяцев назад

Getting 614 error after opening opening sap logon through this code

@CustAndCode 9 месяцев назад

SAP GUI must be closed. I assume that your SAP GUI was open when you tested the code? 🤔

@adrianm.dragomiroiu5548 6 месяцев назад

@@CustAndCode Hi man! When I run the script, it opens SAP Logon, connects to my system but I can't set the session variable due to the following error. Any ideas ? Run-time error '614' The enumerator of the collection cannot find an element with the specified index. This is the relevant code: Set SAPGui = GetObject("SAPGUI") Set App = SAPGui.GetScriptingEngine Set connection = App.OpenConnection("SYSTEMNAME", True) Set session = connection.Children(0) 👈

@gege4707 5 месяцев назад

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

@CustAndCode 4 месяца назад

Fiori no problem, SAP GUI could be a problem because it is not a web application. 🙄 But I am not an expert about SSO.

@mariuszdekier1 9 месяцев назад

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

@CustAndCode 9 месяцев назад

You have a typo error here "i" is missing --> App.OpenConnect(i)on("PROD", True) 🤗

@mariuszdekier1 9 месяцев назад

@@CustAndCode OMG!! Thanks :)

@CustAndCode 9 месяцев назад

@@mariuszdekier1🤪🤗😀

@mariuszdekier1 9 месяцев назад

@@CustAndCode I have another problem. I want to download some data from SAP. Onfortunatly SAP generate it to long and I get messagebox from Excel about waiting for another OLE aplication. Have you got some Idea how I can add some breake in code?

@CustAndCode 9 месяцев назад

@@mariuszdekier1 I have here an application.wait command in my VBA script. 🤔