Automate SCREENSHOT Capture with Excel VBA & SAP Script
Вставка
- Опубліковано 8 вер 2024
- 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!
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!
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?
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.
Thanks for this video. Next I request to video me - Excel to automation SAP screen short and paste to email. Thanks
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?
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. :)
Good