Automate SCREENSHOT Capture with Excel VBA & SAP Script
HTML-код
- Опубликовано: 9 фев 2025
- 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...
Ever wanted to automatically capture and crop screenshots for your SAP automation? This video is your ultimate guide! Learn how to:
✅ Trigger screenshots using VBA
✅ Paste screenshots into Excel worksheets
✅ Crop and resize images for perfect presentation
📚 RESOURCES IN THIS VIDEO:
SAP Screenshot Automation
joelting.com/d...
#SAPScripting #SAPGUIScripting #SAPAutomation #excelvba
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 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 😜
You are sent from God... Bless ur soul.. subscribed rn
Thanks for the sub
Thank you, Joel!
Thank you for video. I dont need it now im my job but i add video for my playlist with most valuable films :D
Hope it helps!
You are amazing Bhai
Hello Joel! Thank you very much for the videos, they are very helpful! I have a question that I’ve been dealing with, but unfortunately, I can’t figure out if it’s possible or not to copy texts from a note(from attachment list) behind an invoice into Excel using an SAP script, for example, using the VF03 transaction. I have researched this in several places, but I haven’t found a solution. I am running into the issue that it’s not possible to copy text from an SAP HTML Container. Thank you very much in advance for your response!
Hello! If I understand you correctly, you wanted to extract text from a PDF file? I don't think it's possible to read directly from a PDF file. One workaround you may try is to locate the PDF, read the file extract the note using some pattern recognition like regex. I am not very familiar with reading PDF files with VBA though, but from what I see in stackoverflow, it seems plausible.
Please also make a video on how to create multi lines PO with the help of SAP Gui Script and thanks a lot for sharing such informative videos and giving us a thought how we can use SAP Gui Script and VBA to decrease the work load of repetitive task.
Will take that into consideration for future videos. Thanks for the suggestions!
@@JoelTing Thanks for considering my request and will wait for this particular video.
Hi there, I took a look at the T-code for creating multi-line purchase orders. I'm not very familiar with how this process works in operations, so I might not be the best person to advise on how it could be implemented.
@@JoelTing Thanks for your reply. Please keep on making such informative videos. :)
What if the variable like period change , how do we change the variable month from month to month
Hello! One way to do it is to use a cell to store the period that you would like to use, then use VBA to pickup the values and pass them into the script.
Thanks for this video. Next I request to video me - Excel to automation SAP screen short and paste to email. Thanks
Thanks for your video, can you create a video for copying job list from SM37 to excel file?
vba will fill up the table from SAP to Excel
Hello! I'm not sure how T-code SM37 works. What are the troubles you are having developing a script around that specific process?
Thanks for this, but i like the native SAPGUI approach
session.findById("wnd[0]").HardCopy "C:\\screenshot.jpg", 1
Thanks for sharing this. This seems to be a better approach for SAP GUI screenshots. I'll definitely try that out. Thanks!
Thanks u both!
Help🥺 how to fix the picture that turns black when I use this code. I need to focus the screen on SAP so it can perfectly screenshot what I need
@black1Ply
Wow excellent video, Can you please make video for dynamic change indexselection in Sap where we are uploading invoice in stored business in SAP.
Hi there, not too sure what you are referring to there. I have most of my experience working on Finance related SAP module. Are you referring to any specific T-codes?
Good
Can you please share the code?
Hello. I have provided it in the description box. Feel free to download it.
Sir I automated the label printing by scriptting it in excel. When script run then it open word file which show how label will show and then script run further now my things is that how can this be automatically save in my desire folder
Hello! I'm not entirely certain about your case. You should be able to interact with the word doc. From there, you should be able to save it just like your Excel file in VBA.
@JoelTing ya if I can do it manually I can save it I want it save automatically
@@Riyaz313 does the word document opens itself? does the word document have the same name for each script run?
@JoelTing yes it's open it's self and have different name every time. So I can have lists of labels in specific folder 📁 so I have record that how many label I have given
@@Riyaz313 If you are familiar with VBA, you can try to get the word application using getobject method, then you would be able to connect to the word document and save it into your desired folder. You may need to establish a loop to keep the script waiting until your word document is loaded before connecting to it. That would be the approach I'll try. As I do not have a use case from my end, I cant be sure if it will work.