I was looking a lot for something that helps me with VBA SAP Scripting + Power automate desktop. This double "%" was the solution!!! Thank you so much!
Hi Joel Ting. Thanks so much for your sharing. I am very interesting with your chanel. It is very helpful. I learn more knowledge from your video. I hope you produce more and more video like this. Thank you.
Glad you liked it! Do you find SAP scripting using VB in Excel more flexible? I do agree scripting with VB in Excel is more powerful, but some may find it hard to follow as the UI is not as friendly as Power Automate.
@@JoelTing working with VB might be difficult but for most of the people working with Xcel is much easy especially if they want to upload data back to SAP like making PO or booking order in SAP using xcel VB scripting
@@mahh1956 agree with you on this. Thanks for the suggestion! I'll see how I can structure this and perhaps make some videos on accessing SAP with VB going forward.
This is another aweson video, thanks!1 i would like to see more examples with Power automate and SAP as well, but it would be good to see an example by transferring the VBS to the VB editor in excel and run it, i now that in this case we need to create some variables and also get the proper connections but it would be nice to see an step by step process for this scenario.
Hi there. It depends on what you want to achieve. If it is just pasting it as a list in the selection criteria, then you can just copy and paste like in the video. However, if your report is by customer, then you can do a loop. Get the list of customer ID, then pass in the ID into the script, one at a time.
Hi there, the script is just the automation of SAP user interface. It's not a direct connection to SAP database server. If you want to link it the manual way, one of the option is to have Power Query read from a folder, and you just save the Excel exports into the folder with the script, and you can refresh that connection after running the script.
Hi there. For this specific process, it's just taking the range of cells and copy, and then paste it in SAP. The value is not stored somewhere. It works more like how we do copy and paste. The copy cells from Excel worksheet step perform the "Copy" or "Ctrl+C" function, then in the SAP script, the button "Paste from Clipboard" is being clicked on.
@@sunoklee8803 hi there, yes. Both can do a clipboard copy. For Excel VBA, it would be the copy method on the range. For Python, there could be multiple ways to do so. One way is to use dataframe.to_clipboard function after loading your data into the dataframe.
hello,Joel Ting, thanks for your excellent video. I am learning on how to apply power automate into accouting works. And meet one problem. When I try to download attachment from sap, this script can not be run on power automate, do you meet the same problem?
Hi Lei King, I did face some problem with automating the downloading of attachments from SAP. I'm not able to download the attachment if the attachment is not available for export (ie archived document type).
Thanks a lot Joel! This tutorial works great and definitely helps to improve my productivity. May I check how to apply this to Tables? I find the script to be different on SE16N tables.
Hi Sean, how does SE16N tables work differently for you? If you record it while you are working on it, are you able to use the recorded script to perform the same task?
From what I have searched around online, there is currently no straight forward way to do that within Power Automate Desktop. One of the workaround is to develop macro to do the filter on it and trigger the macro with PAD as what I have shown in the video. The other workaround is using keyboard shortcut, but I personally think this would make things slightly more complicated.
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](/img/1.gif)
I was looking a lot for something that helps me with VBA SAP Scripting + Power automate desktop. This double "%" was the solution!!! Thank you so much!
Thank you for the qualitative content!
Excellent videos. Very helpful to all
Exactly what I was looking for. :-)
Thank you!
Its great if it does work with double % sign, i stucked at 3:20, will try with % double then will share feedback, thanks 🙏🙂anyway
Hi Joel Ting. Thanks so much for your sharing. I am very interesting with your chanel. It is very helpful. I learn more knowledge from your video. I hope you produce more and more video like this. Thank you.
Hi Bui Giang, thanks for the kind words!
@@JoelTing I am waiting for your new video. When? 😉
your tutorials are great , i would love to learn some easy way to access SAP using VB in Excel for downloading and uploading data from SAP
Glad you liked it! Do you find SAP scripting using VB in Excel more flexible? I do agree scripting with VB in Excel is more powerful, but some may find it hard to follow as the UI is not as friendly as Power Automate.
@@JoelTing working with VB might be difficult but for most of the people working with Xcel is much easy especially if they want to upload data back to SAP like making PO or booking order in SAP using xcel VB scripting
@@mahh1956 agree with you on this. Thanks for the suggestion! I'll see how I can structure this and perhaps make some videos on accessing SAP with VB going forward.
Great tutorial 👌
Thank you! Cheers!
This is another aweson video, thanks!1 i would like to see more examples with Power automate and SAP as well, but it would be good to see an example by transferring the VBS to the VB editor in excel and run it, i now that in this case we need to create some variables and also get the proper connections but it would be nice to see an step by step process for this scenario.
Great suggestion! I will think about it and include it in my future video list.
How to run customer report for large number of customer I'D? By adding loop?
Hi there. It depends on what you want to achieve. If it is just pasting it as a list in the selection criteria, then you can just copy and paste like in the video. However, if your report is by customer, then you can do a loop. Get the list of customer ID, then pass in the ID into the script, one at a time.
Is it possible to get the SAP response via a power query connector?
Hi there, the script is just the automation of SAP user interface. It's not a direct connection to SAP database server. If you want to link it the manual way, one of the option is to have Power Query read from a folder, and you just save the Excel exports into the folder with the script, and you can refresh that connection after running the script.
Joel, there's something I yet don't understand. In which part of the video are you "connecting" the excel column and copying into SAP?
Hi there. For this specific process, it's just taking the range of cells and copy, and then paste it in SAP. The value is not stored somewhere. It works more like how we do copy and paste. The copy cells from Excel worksheet step perform the "Copy" or "Ctrl+C" function, then in the SAP script, the button "Paste from Clipboard" is being clicked on.
@@JoelTing thanks Joel, I'll check that part
can this work with python or excel VBA? clipboard copy of Material listed
@@sunoklee8803 hi there, yes. Both can do a clipboard copy. For Excel VBA, it would be the copy method on the range. For Python, there could be multiple ways to do so. One way is to use dataframe.to_clipboard function after loading your data into the dataframe.
hello,Joel Ting, thanks for your excellent video. I am learning on how to apply power automate into accouting works. And meet one problem. When I try to download attachment from sap, this script can not be run on power automate, do you meet the same problem?
Hi Lei King, I did face some problem with automating the downloading of attachments from SAP.
I'm not able to download the attachment if the attachment is not available for export (ie archived document type).
Thanks a lot Joel! This tutorial works great and definitely helps to improve my productivity.
May I check how to apply this to Tables? I find the script to be different on SE16N tables.
Hi Sean, how does SE16N tables work differently for you? If you record it while you are working on it, are you able to use the recorded script to perform the same task?
How can I capture the Bottom Info in Case error appears
Hi Ammad Khan, you can try session.findById("wnd[0]/sbar").text to capture the text in the status bar.
Hi Joel, May I know how to copy excel data if the excel file name will be change every time
Hi Mandy Leung, putting automation a side, if the Excel file name changes every time, how would you identify which Excel file to read from manually?
Superb!
May I have the video of filter excel table with Power Automate Desktop?
From what I have searched around online, there is currently no straight forward way to do that within Power Automate Desktop. One of the workaround is to develop macro to do the filter on it and trigger the macro with PAD as what I have shown in the video. The other workaround is using keyboard shortcut, but I personally think this would make things slightly more complicated.