[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel

Stop wasting time on tedious, monotonous tasks in SAP.

4.77 (62 reviews)
Udemy
platform
English
language
Other
category
696
students
1 hour
content
Sep 2022
last update
$29.99
regular price

What you will learn

You can automate processes via SAP GUI scripting.

You can name the advantages of SAP GUI Scripting in automation.

You can explain what SAP GUI Scripting is used for.

You can make the system settings required for SAP GUI Scripting.

You can integrate SAP GUI scripts into Microsoft Excel via VBA.

You learn how to start/stop SAP GUI scripts for automation.

You can explain what to do in case of a SAP GUI script error.

You can explain the advantages and disadvantages of SAP GUI Scripting.

Description

SAP GUI Scripting is an automation interface that allows end users to automate repetitive tasks by recording and executing them through a macro-like script. It is a simple tool for robotic process automation (RPA). The interface has existed since SAP FrontEnd version 6.20 and comes standard at no additional cost. SAP GUI Scripting uses the methods and properties of individual objects in the SAP GUI to perform actions and/or read data. All tasks that a user can perform manually can be automated with SAP GUI Scripting. SAP GUI Scripting is an example of the integration between SAP and Microsoft Office.


This course teaches you how to integrate your SAP GUI script with Microsoft Excel using Visual Basic for Applications (VBA). For this integration you will need a free Microsoft Excel add-in (SAP GUI Scripting API). Automation via SAP GUI Scripting is fairly simple, inexpensive and straightforward. Therefore, there are almost no corporate hurdles in introducing this technology. This is one core advantage over other solutions (ABAP program, LSMW, etc.).


SAP GUI Scripting can save a considerable amount of time for many business processes. The time saved can then be used for more demanding tasks. The errors avoided by automation save follow-up costs and remediation time.

Content

Introduction

How do you automate the SAP data entry process with Microsoft Excel?
How is the course content structured?

Settings

How do you install the SAP GUI Scripting component?
What user settings are relevant for SAP GUI Scripting?
What parameters are relevant for SAP GUI Scripting?
How do you activate the SAP GUI Scripting API in Microsoft Excel?

Recording

How do you record your first SAP GUI script?

Integration

How do you integrate your SAP GUI script into Microsoft Excel?

Application

How do you execute your SAP GUI script?
What do you do in case of errors?

Conclusion

What are the pros and cons of SAP GUI Scripting?
What do your next steps look like?

Screenshots

[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Screenshot_01[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Screenshot_02[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Screenshot_03[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Screenshot_04

Reviews

Jeanette
September 16, 2023
Well detailed explanation! Easy to follow and not boring! The side by side videos showing excel and sap gui is very helpful :) I love to have another session like this but different topic! Thank you!
José
February 2, 2023
Muy bueno cumple mis expectativas quisiera que hicieran un 2°do curso mas detalle en bibliografia etc para tener un nivel mas avanzado en la programicion de SAP vs Excel en toma de desiciones
W.
December 29, 2022
Very nice course! Could you just please also add the chapters for downloading data from SAP (like in the german version)? Nevertheless, great course, everythin is explained in detail.

Charts

Price

[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Price chart

Rating

[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Ratings chart

Enrollment distribution

[ENG] SAP GUI Scripting: SAP automation with Microsoft Excel - Distribution chart

Related Topics

4807220
udemy ID
7/30/2022
course created date
9/13/2022
course indexed date
Bot
course submited by