Automate SAP Data Extraction with Excel VBA & SAP GUI Scripting - Minimal Coding Required

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!

As an analyst in one of the MNC, I'm always extracting data from SAP to prepare reports for different users.

I saved a lot of time automating these extraction process. After the automation is done, I will just have to click on a button which will trigger a script and the data would have been extracted

In this video, I'll break down exactly how I use Excel VBA to automate the process of extracting data from SAP.

Timestamps
00:00 Introduction
00:13 Why Excel VBA?
00:50 SAP GUI Scripting Basics & Recording Tool
02:00 Preparing Microsoft Excel for SAP GUI Scripting
02:33 Preparing Visual Basic Editor for SAP GUI Scripting Development
03:07 Create variables and establish connection with SAP GUI with template
03:44 Complete sub-procedure with SAP recorded script
04:16 Editing script to make it dynamic based on users' inputs
06:20 Create shortcut to run SAP script with a single click
06:48 Completed script test run demo
08:54 Summary/Recap of SAP Data Extraction Automation

#SAPScripting #ExcelSAPAutomation #SAPScriptingwithVBA

Code Template used in the video:

Option Explicit
Public SapGuiAuto, WScript, msgcol
Public objGui As GuiApplication
Public objConn As GuiConnection
Public session As GuiSession

Sub SAPDownloadAttachment()

Set SapGuiAuto = GetObject("SAPGUI")
Set objGui = SapGuiAuto.GetScriptingEngine
Set objConn = objGui.Children(0)
Set session = objConn.Children(0)

'Insert your SAP Script here

End Sub

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. I do not recommend the use of SAP Access from any particular provider.

🤝 BE MY FRIEND:

🙎🏻‍♂️ WHO AM I:
I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity.

📧 GET IN TOUCH:

[JoelTing]

I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below:

[stevejohnson]

Hi Joel, I am now able to get the macro to work.
I want to convey my sincere gratitude for your videos. Your videos will help countless professionals enrich their skills and to be more productive in their work. Keep up the GREAT WORK.

[Rajuuutube]

Hi Joel, Awesome presentation. The information provided in the video is fabulous. Thank you!

[yogeshloganathan]

Hi Joel, thanks for your video. I was looking for Excel VBA for beginners and I found your video which is very useful and easy to understand.

[satheshs]

Hello Joel,
Thank you so much for this lesson. I was able to use it. You have my love and respect. God bless you!!.

[pauline]

it's my first time creating VBA and your tutorial works wonder, huge thanks!

[dcpowered]

Hi Joel, this video is a goldmine of information! The only one that clearly explains the steps. Please keep posting new videos on SAP automation and SAP data extraction. Is it possible to automatically upload the extracted multiple Excel files to a SharePoint folder?

[thanhphamduy]

It's exactly what I need. Very helpful. Thank you.

[jameslimpin]

Hi Joel, this is a great video. Thank you for sharing your valuable expertise.

[mood]

Great job as always Joel. Keep up the good work!

[fdkt]

What a great Video
The explanations are so clear. Thank you very much!!

[sabbaghuss]

Hello Joel, Thank you so much, this video is very amazing and helpful, i am very grateful for your great work.

[mahh]

HI Joel, You have really solved my problem, i really like the way you make difficult task easy enough for new comers to understand, i would appreciate if you can also explain how we can run multiple VB scripts for download various reports from SAP in one single click, i believe it will a piece of cake for you as usual .

[arboflix]

I made it for the 1st time. Thank you. 😊

[jesseniatavares]

I gave this video a like, but I wish i could give it a LOVE!!! This is amazing, THANK YOU!

[thanos_sk]

What an amazing video that was! Thank you so much!

[soundofssap]

Thanks for good video. Very clear & useful.

[luisramirez]

Excellent video. Very interesting option and I will be looking for ways to apply this to my day to day work. Thanks

[Carla]

With these kinda videos you know that the word ''genious'' is badly used sometimes. Thank you, I hope to be able to do it myself :D

[leandrocarvalho]

Hi Brother!!!
You are truly amazing! For distribute such rich knowledge in a simple and right way...

Congratulations!!!