• Post category:StudyBullet-10
  • Reading time:4 mins read


Use Excel VBA coding to download reports from SAP

What you will learn

SAP basics

Excel VBA basics

Integrate SAP and Excel for reporting purposes

Useful macros for everyday life

Description

Nowadays Microsoft Excel and SAP Software are used in many companies by many users. Most of the people are not aware that they can create powerful macros in Excel to automate their daily tasks. Even more people are not aware of scripting option in SAP which allows us to record every action we did.

Let’s integrate these two tools Excel & SAP to create reports for our colleagues and business partners and save a lot of time.

In this fast-paced course you will learn basics about SAP and Excel VBA and as a main goal how to create Excel macros to download reports from SAP and you will see that it is not so difficult how it probably sounds.

Little knowledge of SAP and MS Excel is required. I will show you steps to integrate these two beasts which are very easy to follow, so within one day you will know how to create automated Excel which can perform basic tasks in SAP.


Get Instant Notification of New Courses on our Telegram channel.


In extra section you will learn few other macros which are very useful for daily tasks and are great time savers.

I believe that time saving is very important in our work and in our lives so this course is pretty fast-paced to get right to the point.

Do not hesitate to join this course and let’s learn!

English
language

Content

Introduction

1.1 Introduction
Please read!

SAP Overview

2.1 What Is SAP?
2.2 Importance Of SAP
2.3 SAP ERP Use Cases

VBA Overview

3.1 What Is VBA?
3.2 Common Uses Of VBA
Why To Use VBA?

System Setup

4.1 Excel Setup

SAP Scripting

5.1 Scripting Intro
5.2 SAP Setup
Our First Script

Macro Creation

6.1 Creation Of Our First Macro
6.2 How To Run macros?
6.3 Completing Our Macro
6.4 How To Avoid Notifications When Our Macro Is Running

Conclusion

7.1 Outro

Extra

8.1 Open Workbooks Macro
8.2 Copy & Paste Macro
8.3 Close Workbooks Macro