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/
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.
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!
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.
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 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 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
Sir i have made a me51n pr transation code that to extract data from excel to sap im able to do it for the first line for making multiple lines what are the alterations that i should make
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.
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
Hi Joel, this video was mind blowing. if you have time please make a VBA for F-28 post customer incoming payments, because i struggle design VBA for incoming some billing reference number if there's customer pay for their 1 billing or more than 1 billing.
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?
hi Joel, why my sap shows this message 'Input must be in the format _,___,___,__~.___V'. i dont see any issues on your video showing any issues when data being transfer from excel to SAP. any idea to fix this? Anyhow, your video was very helpful & i followed step by step
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.
The problem already solved by adjusting a little bit the script. Now I managed to run the script completely 1 cycle until the transaction is saved. unfortunately, it won't loop to proceed with other order nos. When i try to run it mentioned about couldn't found the ID? What could be the issue... Is it SAP settings or the script itself?
@@fadlyriza6314 That's most likely your session is not at the correct screen to input another order. That error shows that it is not able to find the field you specify to fill in the value. You can try putting in "/n" in front of your transaction (ie. /nMM03)to make sure it will always go to the main transaction page for you to perform your processes.
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.
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.
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
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
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
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](/img/n.gif)
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/
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!
Thanks for your support! 😊
Dear Joel...Thanks a lot for this valuable video....
Your videos are very informative and helpful for new learners like me.
Thanks for the effort
It's really mind-blowing with your tutorials
Great job 👌👍👍👍
As always, thank you Joel!
Hi joel, your video was very helpful, i followed all the steps as per the video but unable to process the second line from the table which i need
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
Thank you so much. It's a wonderfull.
Please up more videos.
I'll try to do so! Hopefully this is helpful for you!
Impresive.😊 Super useful for me. Thanks!
Glad it was helpful!
It is amazing! Thanks for the video!!!
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.
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
Sir i have made a me51n pr transation code that to extract data from excel to sap im able to do it for the first line for making multiple lines what are the alterations that i should make
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
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!🙏
You are a genius 😍
Thanks! :)
Hi Joel, this video was mind blowing. if you have time please make a VBA for F-28 post customer incoming payments, because i struggle design VBA for incoming some billing reference number if there's customer pay for their 1 billing or more than 1 billing.
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?
hi Joel, why my sap shows this message 'Input must be in the format _,___,___,__~.___V'. i dont see any issues on your video showing any issues when data being transfer from excel to SAP. any idea to fix this? Anyhow, your video was very helpful & i followed step by step
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.
The problem already solved by adjusting a little bit the script. Now I managed to run the script completely 1 cycle until the transaction is saved. unfortunately, it won't loop to proceed with other order nos. When i try to run it mentioned about couldn't found the ID? What could be the issue... Is it SAP settings or the script itself?
@@fadlyriza6314 That's most likely your session is not at the correct screen to input another order. That error shows that it is not able to find the field you specify to fill in the value. You can try putting in "/n" in front of your transaction (ie. /nMM03)to make sure it will always go to the main transaction page for you to perform your processes.
This is really useful... thanks
Thank you for the informative video, I like it!
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.
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 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.
th-cam.com/video/lFLIwcRi0_U/w-d-xo.html
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?
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
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.
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 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! 😊
짱