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.