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 🤗
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?
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! 🤗
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.
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.
@@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) 👈
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 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?
![Export SAP Data to different Excel Files with SAP GUI Scripting & Excel Macro VBA [english]](http://i.ytimg.com/vi/AreBoOta5u8/mqdefault.jpg)
![Export SAP Data to different Excel Files with SAP GUI Scripting & Excel Macro VBA [english]](/img/tr.png)
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](http://i.ytimg.com/vi/8nvCW-l2Jdc/mqdefault.jpg)
Thank you very much, it still works for SAP 7.0.
Thanks for your feedback! 🤗😀 I apprechiate it!
Like BDC tool :) Good to have it in excel too :)
Yes 🤗 For some reasons it is really handy to have this in excel. 😀
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.
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
🤗
How to add if context to open sap.exe only if it’s not currently on.
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?
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! 🤗
Maybe you can try this tool: tracker.stschnell.de/ 🤗
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.
Maybe something is null or empty which is not allowed. But I don't know exactly. 🤔
Do i need to have abap authorisation for it to use?
We do not use ABAP here. You only need the right to call the transaction se16 (for this example) 🤗
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.
Getting 614 error after opening opening sap logon through this code
SAP GUI must be closed. I assume that your SAP GUI was open when you tested the code? 🤔
@@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) 👈
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
You have a typo error here "i" is missing --> App.OpenConnect(i)on("PROD", True) 🤗
@@CustAndCode OMG!! Thanks :)
@@mariuszdekier1🤪🤗😀
@@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?
@@mariuszdekier1 I have here an application.wait command in my VBA script. 🤔
Does anyone know how to logon to sap when SSO is being used?
Fiori no problem, SAP GUI could be a problem because it is not a web application. 🙄 But I am not an expert about SSO.