I created 20 vendors in SAP with a SINGLE click with Excel VBA!
Vložit
- čas přidán 14. 08. 2024
- Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!
joelting.com/s...
📚 RESOURCES IN THIS VIDEO:
Vendor Creation Automation:
drive.google.c...
Automate the creation of vendors using SAP Scripting and Excel VBA! Learn step-by-step how to record the script, develop the solution using Excel VBA, send data from Excel into SAP and retrieve information displayed in SAP GUI back to Excel.
Stay tuned for our upcoming comprehensive course on SAP Scripting and Excel VBA fundamentals. Join the waitlist now using the link above! Like, subscribe, and hit the bell icon for more SAP and Excel tutorials. Enhance your workflow today!
#SAPScripting #SAPGUIScripting #ScriptingTracker
DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.
MY FAVOURITE TOOLS & GEAR:
📝 Notion - How I Manage My Day - affiliate.noti...
💻 My Personal Laptop - Legion 5 Pro - amzn.to/3nZrn1I
✈️ My Travel Companion - Macbook Air M1 - amzn.to/43jLLuE
📷 My Camera Gear - Sony ZV-E10 - amzn.to/40T7uIj
MY OTHER SOCIALS:
🌍 My website / blog - joelting.com/
🐦 Twitter - / joelting92
🏢 Linkedin - / joel-ting
🙎🏻♂️ WHO AM I:
I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation and productivity.
📧 GET IN TOUCH:
If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.
P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links 😜 - Věda a technologie
I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below:
joelting.com/sap-ebook/
Your videos are very informative and helpful for new learners like me.
Dear Joel,
I am very proud to see all the videos you make about SAP VBA. Please, if you have time, make a VBA sap code F-02. I hope all your work is useful for everyone.
Thanks for the suggestion!
U should try yourself first.
Best way to learn is practicing
Clear explanation. Just want to add. Catching errors is also a necessity.
Hello! The script includes a line where it records the text from the status bar once the save button is hit. This essentially serves to document any error messages that might appear when the vendor creation failed. I concur that handling errors effectively is crucial. Given the intricacies involved, it probably deserves a separate video entirely. However, my concern is that incorporating this into the current video might overcomplicate things, especially since this content is designed to assist beginners in getting started with learning the basics. I appreciate your feedback and will make sure to clarify this point in upcoming videos. Thank you for your input!
Thanks for the effort
It's really mind-blowing with your tutorials
As always, thank you Joel!
Dear Joel...Thanks a lot for this valuable video....
Thank you for the informative video, I like it!
It is amazing! Thanks for the video!!!
Impresive.😊 Super useful for me. Thanks!
Glad it was helpful!
Thank you so much. It's a wonderfull.
Please up more videos.
I'll try to do so! Hopefully this is helpful for you!
Thanks!
Thanks for your support! 😊
You are a genius 😍
Thanks! :)
This is really useful... thanks
joel love your videos . if you can make us a long tutorial for finance sap fico and excel . from extracting data to manipulate in excel and automate it
Thanks for your kind words. Sorry, I have been quite busy recently. I'll see what I can do.
i don't know if you're familiar with business controlling the capex analysis and the sales analysis if you make a tutorial about this to will be wonderful and again thank your for sharing your knowledge with us
Hey there, may I know specifically what T-code you are usually looking at for CAPEX analysis and sales analysis?
@@JoelTing thanks for replying . I'm open to anything do what you can do i know you don't have much time i really appreciate every type of information you give us
How does this ocmpare to using Power Automate for SAP scripting?
Do you get more custom behavior out of this?
Hello! Power Automate is more user-friendly and you can achieve similar things with it. I find that VBA offers more flexibility when it comes to customizing code as everything is just lines of codes. If you are using Power Automate, you need to break that down into different blocks, increasing development time. This advantage becomes even more apparent as your automation projects becomes more complex.
짱
Please make a video about SAP table scripting. Thank you so much
Hi there. Do you mean how to get data from SAP tables? Or usually what did you do with SAP tables?
Hey Joel, thanks for the video. I have something very similar to what you did in your video. So, after I added the variable of lastrow to the watches and run the script. But received an error message "Run-time error '619': The control could not be found by id. This is the line where it stopped : Session.findById("wnd[0]/usr/ctxt/CUM/CUNIT_IO-CUTYP").Text = "2" (Script from SAP). Do you have any suggestions how to resolve it? Thanks so much.
Hi there! This line returning error means that there's something different when the script is running compared to the time you recorded it and it is not able to locate the object you identified in the script. Would you be able to identify the difference? Try running line by line and you should be able to see why it is not able to fill in "2". The field may not be there at the point of the script.
@@JoelTing Thanks for the explanation. I think I have resolved the issue. However, I have another question as far as the "Business Partner" number you extracted from SAP and populated to the Excel sheet. That part, on my screen, once I clicked "Save", it will go to the first screen and the number created will show on the side bar (lower left corner). In this case, do you think I still can click on number on the side bar and record the SAP GUI Script? Thanks a bunch!
I'm assuming the text from the lower left corner that you are referring to is the status bar. The text can be retrieve using the line below:
session.findById("wnd[0]/sbar").Text
You can even check if it is successful, or it returns error using
session.findById("wnd[0]/sbar").MessageType
@@JoelTing yes, status bar, sorry. Let me try and see if it works. Thanks
@@JoelTing everything works well. I appreciate your help!🙏
Please record video for VBA scripting on how to take SAP screenshot in excel
I'll take note of that. Thanks!
Hi there, I just released a video for taking SAP Screenshot with VBA.
czcams.com/video/lFLIwcRi0_U/video.html
I recorded a script for purchase order creation and tried with excel vba....sometimes it works and sometimes it does not....there is some problem with ID....SAP is changing control ID's...How to tackle this problem?
Hi there, typically, it shouldn't change unless something different occurs. If you encounter any unexpected changes, such as additional pop-ups for certain items during the purchase order creation, you'll need to use conditional statements to handle these situations. For example, if it encounters this specific ID, then it should follow a designated action.
Hi friend, I hope you are doing well. I have a quick question for you. It is possible to execute parallel download using SAP and vba?
I know that you can utilize different sessions at the same time to execute different downloads, but personally, I have not tried it that way myself.
Hi please help
I'm getting a error while running the script to get last row value
Error: Run time error 91
Object variable or with block variable not set
Hi there. Have you declared the variable before assigning values to it? like Dim lastrow
Hello Joel, May I ask you two questions? 1. If a T-code runs quite a long time(10mins) to get the result, the vba will remind no respone to wait ? How can we process this issue, is it possible to let the sap scripting run in background even I run it in new window? 2. When I use sap GUi scripting, I cannot upload file with the default sap dialogue. No window pop up to let me select file. Thank you very much.
Hello!
1. You can try to temporarily disable alerts by setting Application.DisplayAlerts = False before running the script, and then revert it back to True afterwards. This should suppress VBA from displaying reminders and warnings, allowing your script to run uninterrupted.
2. Is it possible to see if it would trigger the upload dialogue? Try to input the full file path and see if it would trigger the upload. As SAP GUI scripts are unable to interact with Windows pop-ups natively, so this method is actually preferred.
@@JoelTing Thank you very very much. I will try point 2. Regarding point 1, maybe I describe it not correctly, it seems when the macro runs into a long time ,vba goes into no response mode.
@@zhimabukaimen I believe that’s typical behavior for VBA. When running macros, Excel stops responding to user input. One workaround is to develop your automation script with Python. This way, you can continue to use Excel without interruption while the script is running.
@@JoelTing Thanks Joel, I just got your GUI scripting basic ebook, after finishing it I will try to find other solution of python with your suggestion.
Thanks for your support! Hopefully it will help you to gain a deeper understanding of SAP GUI script. Do let me know if you need any help!
Please help
I get error when exporting data from sap to excel :
Excel waiting for an OLE Action, while running an SAP script
So i have to click OK in order to continue, which is annoying because then it pops-up non-stop and i have to do it like 10 times in order to reach the goal, which removes the point of automation.
Hi there, I found this while researching on the topic. Hopefully this can help you to solve your problem.
stackoverflow.com/questions/44288799/how-to-deal-with-microsoft-excel-is-waiting-for-another-application-to-complete
@@JoelTing Thank you JoelTing
Hello I want to create a play button in excel for pasting comments in SAP. Please help anybody.
Hello! Is there any steps that you are having trouble with?
@@JoelTing Hello, is their anyway I can connect with you Insta, telegram, discord anything?
You can reach me personally via my email joelting92@gmail.com
@@JoelTing You got a new subscriber buddy. ❤️
Thanks for the sub! 😊