Automating SAP with Excel

preview_player
Показать описание
This is one of the few tutorials I do without Python. That's because VBA works a lot better with SAP because SAP has script recording in VBA.

I this training I show you how I have recorded manual process from SAP. Loaded them to Excel and used VBA to automate a process of taking screen prints. Also I discuss a little about how it can be used for a data pull.

To get the example file visit by Blog.

  1. Python-Dave
Рекомендации по теме
Automating SAP with 0:17:49

Automating SAP with Excel

Automate SAP Data 0:08:02

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

Automate SAP data 0:09:36

Automate SAP data extraction to Excel with Power Automate Desktop - No Coding Required.

Export SAP Data 0:09:47

Export SAP Data to different Excel Files with SAP GUI Scripting & Excel Macro VBA [english]

Copy Excel Ranges 0:03:27

Copy Excel Ranges and Paste into SAP Multiple Selection | SAP Scripts with Excel VBA

Automatic Data Entered 0:02:26

Automatic Data Entered From Excel to SAP VBA Coding

Automate Data Extraction 0:14:20

Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]

I created 20 0:08:18

I created 20 vendors in SAP with a SINGLE click with Excel VBA!

SAP Fiori/UI5 Full 0:24:38

SAP Fiori/UI5 Full Stack Project Development Tutorial | Day 1: Project Introduction and Overview

SAP to Excel: 0:13:58

SAP to Excel: Automate the export of SAP data to Excel ⚡

9. Excel Macros 0:07:12

9. Excel Macros (VBA) - Analysis for Office (A4O) Automation (SAP BW)

VBScript - SAP 0:00:38

VBScript - SAP GUI Export to Excel - How to connect and Save as automatically

Fill Excel automatically 0:02:50

Fill Excel automatically with SAP Build Process Automation

Automate SCREENSHOT Capture 0:09:45

Automate SCREENSHOT Capture with Excel VBA & SAP Script

SAP GUI Scripting 0:00:19

SAP GUI Scripting :- Running through Excel VBA, Downloading bulk Invoices from SAP. #sap

SAP Automation with 0:20:45

SAP Automation with Power Automate Desktop (Full Tutorial)

Automate Bulk PDF 0:12:25

Automate Bulk PDF Extraction with Excel VBA and SAP GUI Scripting

Open SAP GUI 0:08:38

Open SAP GUI automatically with Excel VBA and run Scripts (SAP GUI Scripting) [english]

Connecter SAP à 0:14:39

Connecter SAP à EXCEL - SAP GUI Scripting

Using Power Automate 0:10:34

Using Power Automate with Excel to update SAP data

SAP GUI Scripting 0:47:34

SAP GUI Scripting 1 - Running scripts from Excel

Export multiple SAP 0:06:10

Export multiple SAP reports with For Loop in Excel VBA - SAP GUI Scripting

7. Excel Macros 0:09:15

7. Excel Macros (VBA) - Automation of SAP

Automate Goods Receipt 0:01:11

Automate Goods Receipt (MIGO) in SAP with Excel VBA

Комментарии
Автор

Hello! Dave Rudd, Excellent tutorial on SAP-Excel scripting. Can you please upload a work instruction or let me know where to download the file which you see in the video at 3:45min The excel file with instruction for SAP-Excel will be very beneficial. Thank you.

Sharuc.
Автор

How would you compare this method against methods you can do in microsoft power automate?

josephdaquila
Автор

sorry sir, i dont quite understand what instance to put in the line. since i have alot of instance with sub folders. inside sub folder there is one out 15 instance.

the question is how the script will identify where is my instance?

akvstudio
Автор

I want to update SAP data from excel file for tcode MSC2N where I want to update the data for certain material/batches.
I created file to Update MSC2N, but this is for one defined value only and not from excel
Can you please to create excel which can pick data and update MSC2N like Date of Manufacturing, shelf life, vendor batch, country of origin

Kashi_Gujjar_