Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]

In today's video I will show you how to use SAP GUI Script and Excel Macros, that is Visual Basic for Applications, in short (VBA). This can be very useful if you regularly evaluate data from the SAP system and want to process it in an Excel. In the video today, I select data from the SFLIGHT table and put it into an Excel. I extend the generated script with variables that can be entered into the Excel. A button is then created in Excel that can be used to start the script. #SAPGUIScript #Excel #automation Inhalt: 00:00 Intro 00:50 Activate GUI Scripting 01:49 Record Script 04:20 Test Script 06:06 Extend Macro 08:05 Create Button 09:35 Create Variables 13:03 Test Script 14:02 Outro ▬▬ Literature 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬ ▶ ABAP: An Introduction 2020 https://amzn.to/45CLTqk ▶ Complete ABAP 2023 https://amzn.to/45D5UNM ▶ ABAP to the Future 2022 https://amzn.to/42cgWGs ▶ Clean ABAP 2022 https://amzn.to/3KAqmow ▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬ ▶ Microphone: https://amzn.to/3zj2UIz ▶ Headphone: https://amzn.to/3GUBRFg ▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬ ▶ Video Recorder: https://bit.ly/678fgh6 ▶ Video Editor: https://bit.ly/38Rj9lb ▶ Thumbnail: https://bit.ly/CustAndCodeThumbnail ▶ Gamma AI: http://bit.ly/3nsdvgr ▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ⭐Become my subscriber: https://bit.ly/CustAndCodeSub 🎬All videos in English: https://bit.ly/CustAndCodeENG ☕Buy me a Coffee 😀: https://bit.ly/3dih2cl *The links are affiliate links. There are no additional costs. Microsoft excel icons created by Pixel perfect - Flaticon https://www.flaticon.com/free-icons/m... Sap icons created by Freepik - Flaticon https://www.flaticon.com/free-icons/sap SAP® and SAP GUI Scripting are registered trademarks of SAP AG.