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!
https://joelting.com/sap-ebook/

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:
🐦 Twitter -   / joelting92  
🏢 Linkedin -   / joel-ting  

🙎🏻‍♂️ WHO AM I:
I'm Joel, an analyst 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 [email protected] would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.