ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
Automate SAP Data Extraction with Excel VBA & SAP GUI Scripting - Minimal Coding Required
ฝัง
- เผยแพร่เมื่อ 17 ส.ค. 2024
- 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!
joelting.com/s...
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 joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.