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 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬

▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

*The links are affiliate links. There are no additional costs.

Microsoft excel icons created by Pixel perfect - Flaticon
Sap icons created by Freepik - Flaticon
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

[TheFundamentalChristian]

This is great stuff! I look forward to utilizing this code into updating 100s of lines of balances from SAP into Excel. Right now the process is done manually and it takes my team many hours.

[jeslaravishuda]

Thank you so much, I learnt how to download a report that takes 1 hour of my time.

[vijaysenthil]

Thanks for your vedio its very easy to understand

[juliusowan]

Too beautiful! Thank you for sharing this. Is there a way to automate a change of date

[mrronaldino]

Thank you so much this will help me a lot as data analyst. However I am not authorized to use tcode RZ11. I will definitely raise a ticket for this for automation purposes!

[Karimsalah]

thanks the video is very helpful i did it in a few minutes, but Sap needs to be opened, can you please support on how to embed in the VBA Code to open SAP automatically? and also how to make it extract automatically at a certain timing

[zfivvbi]

Thank you for your video. That was very helpful. Can I ask you a question? Is there a way to download all the files attached to the Sap accounting slip by using Guiscript? I don't know how to download the whole thing because the number of attachments is different for each slip.

[DavidRelphWorkLife]

great thanks for the code can you read mutil codes from a range in xL say from A1 to A5 thanks

[surajkumarmahto]

Hi thanks for this its very helpful ....just one query that i wanted to extract data in same. Excel file in which i have created button pls.. help in this

[iougpjz]

awesome stuff man. How do I export SAP data/excel to the Macro enabled spreadsheet. In a way the spreadsheet becomes an app for data extraction...

[TheWanderercontent]

That was great !! How would you adapt the script to pull the table each month ? Like a monthly report

[carlaarenas]

Hi Sir do you have a video that I can follow regarding for example I need to create Info record using transaction code ME11 then I will create Macros and I will run using that. I believe I need to create some headers right?

[demcjqq]

Thank you for your video.what if l want to write a code to close excel file after export it??? Please your support will be appreciated

[nathanmartin]

Tanks for the video it Washington vers helpful!! I just have à question : how do I do to work on a Excel sheet after closing the SAP part ? My code "Application.ScreenUpdating = False" doesn't work...

[dineshshelke]

Thanks for making this video
I need your help where can we connect?

[chauhannaman]

Thank you for the video sir!
I have a query. At 02:56 when after selecting the option from Available formats, you select XLSX format. I did the same but the dialog box for Directory and Filename doesn't come up. File Explorer comes up to save the file. This moves the handle out of SAP's scope and that can't be included in the scripting. Is there any settings I need to tune in my SAP GUI app? I can share further info over the email if you need.

Thank you!

[satyammalhotra]

Hi Sir, Hope you are doing good.
Could you please help me with any formula/vba code for taking dynamic date. Means i always have to extract the data for open line items appearing in end of the month.

Your help would be highly appreciated.

Many thanks for the video and sharing knowledge with us😊

[ahmadghozie]

Hi Sir,
I just try to follow your video. After I create the Macro, and Run the Macro, it didn't work. There's a notif on Microsfot Visual Basic dialog box said that " Run-Time error '619' : The Control Could not be found in id".
please help

thank you

[Bitza]

Hi, getting a runtime error 614, any help please?

[ihlcnwi]

Use full video, one question "Can we use VBA (macros) to upload file from excel to SAP" ?