I created 20 vendors in SAP with a SINGLE click with Excel VBA!

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/sap-ebook/
📚 RESOURCES IN THIS VIDEO:
Vendor Creation Automation:
drive.google.com/file/d/1ye0G...
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.notion.so/hpemzmxen3jq
💻 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 [e-mail] 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 😜

[@JoelTing]

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/

[@dongayrajasekharpanda5844]

Your videos are very informative and helpful for new learners like me.

[@Proactive9002]

Thank you for the informative video, I like it!

[@markjudeestrera]

As always, thank you Joel!

[@gssalian1]

Dear Joel...Thanks a lot for this valuable video....

[@xinyandong8431]

It is amazing! Thanks for the video!!!

[@chualiewmeng1115]

Thanks for the effort It's really mind-blowing with your tutorials

[@kiranarana7274]

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.

[@JoelTing]

Thanks for the suggestion!

[@mathijs9365]

U should try yourself first. Best way to learn is practicing

[@xhmoh530]

This is really useful... thanks

[@oskwon72]

Impresive.😊 Super useful for me. Thanks!

[@JoelTing]

Glad it was helpful!

[@bzflowerbee]

Thanks!

[@JoelTing]

Thanks for your support! 😊

[@mathijs9365]

Clear explanation. Just want to add. Catching errors is also a necessity.

[@JoelTing]

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!

[@camiloandresochoagarcia2453]

Thank you so much. It's a wonderfull. Please up more videos.

[@JoelTing]

I'll try to do so! Hopefully this is helpful for you!

[@kpk9311]

You are a genius 😍

[@JoelTing]

Thanks! :)

[@rachidmohammed6784]

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

[@JoelTing]

Thanks for your kind words. Sorry, I have been quite busy recently. I'll see what I can do.

[@Ben-dl1xs]

Please make a video about SAP table scripting. Thank you so much

[@JoelTing]

Hi there. Do you mean how to get data from SAP tables? Or usually what did you do with SAP tables?

[@zhimabukaimen]

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.

[@rachidmohammed6784]

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

[@JoelTing]

Hey there, may I know specifically what T-code you are usually looking at for CAPEX analysis and sales analysis?

[@rachidmohammed6784]

@@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

[@ManishKumar-pg5sy]

Please record video for VBA scripting on how to take SAP screenshot in excel

[@JoelTing]

I'll take note of that. Thanks!

[@JoelTing]

Hi there, I just released a video for taking SAP Screenshot with VBA. kzbin.info/www/bejne/oneveqqZh85jlbc

[@user-fv7hk8gw6w]

How does this ocmpare to using Power Automate for SAP scripting? Do you get more custom behavior out of this?

[@JoelTing]

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.

[@Acerdaparrales]

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?

[@JoelTing]

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.

[@bzflowerbee]

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.

[@JoelTing]

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.

[@bzflowerbee]

@@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!

[@JoelTing]

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

[@bzflowerbee]

@@JoelTing yes, status bar, sorry. Let me try and see if it works. Thanks

[@bzflowerbee]

@@JoelTing everything works well. I appreciate your help!🙏

[@dongayrajasekharpanda5844]

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?

[@JoelTing]

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.

[@vishwasnaik961]

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

[@JoelTing]

Hi there. Have you declared the variable before assigning values to it? like Dim lastrow

[@kiranarana7274]

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.

[@JoelTing]

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

[@kiranarana7274]

@@JoelTing Thank you JoelTing