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

Thanks for the suggestion!

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

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!

Glad it was helpful!

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

Thanks! :)

Hello! I'm not familiar with the processes surrounding customer incoming payments. Just thinking out loud, could we potentially read the number of billings a customer has made and then, based on the specific billing invoice they paid for, create a loop that iterates through their current outstanding invoices and checks them against the billing they made?

Thanks for your support! 😊

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

Hello! To identify the issue, consider examining two key areas: 1. Verify if the 'lastrow' variable is accurately capturing the correct number. 2. Ensure that the 'i=2, next i' loop is incrementing properly with each iteration. Try to run the script 1 step at a time and see where it went wrong.

@@JoelTing thank you its updated

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

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.

I'll take note of that. Thanks!

Hi there, I just released a video for taking SAP Screenshot with VBA. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lFLIwcRi0_U.html

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

Hello. That seems to be a decimal place field? Could it be a maximum decimal place in SAP? As a first step, try to do it manually to see if it works. You just need to make sure the data you passed into SAP works in the first place. For example, if the SAP field only works with 2 decimal place, you must convert the value into 2 decimal place 1st in VBA before passing it into SAP.

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

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 there. Have you declared the variable before assigning values to it? like Dim lastrow

Hello! To get started, determine the number of lines you'll be working with. Once you have that information, create a loop to input the data into SAP. Try recording multiple lines of input and observe the pattern. You will notice that each line has a row number (1st row is 0) and a column name based on the SAP technical name. By using a loop with a row counter that increments after each row input, you can enter your data line by line into the grid.

@@JoelTing Tq for the response sir

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!

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