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

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!

In this video, I will share how you can export multiple SAP reports with different parameters using for loop in Excel VBA.

Timestamps
00:00 Overview
00:21 Script Recording in SAP GUI
01:27 Develop your script in Excel VBA
02:22 Basic structure of a for loop
04:30 Finishing touches

#SAPScripting #ExcelSAPAutomation #SAPExcelIntegration #SAPVBA

Source File:

MY FAVOURITE GEAR

🤝 BE MY FRIEND:

🙎🏻‍♂️ WHO AM I:
I'm Joel, an analyst working in Singapore. I make videos about technology, automation and productivity.

📧 GET IN TOUCH:

[JoelTing]

I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below:

[dcpowered]

Amazing tutorial! This is a breakthrough! Thank you so much and please keep sharing your new and better methods to extract SAP data!

[luisramirez]

Thanks a lot for providing this resources to help facilitate our daily task at work!

[tomaszkocjan]

Gr8 stuff. It actually helped me to do the opposite with Loop (For i = ... Next i) and import data from Excel to SAP in MAT1.
Thank you

[latestupdatedeepsingh]

Really you have given me a very lovely tricks and I am using in my daily work .100/100

I love you Joel
You saved my lot's of time and please upload more video's
Your videos more useful.

[ecashmarketing]

this is very good stuff, thanks for sharing.

[behanassim]

Mec je t'aime, t'es un génie

[davidtrejo]

Muchas gracias Joel!, muy muy util para mi

[latestupdatedeepsingh]

I am recommending your videos to others .. really, ,I am herlty sying to you you are the best

Please give more video's to us, ,,,

I am working on SAP

It's my firstexpirince

[saojoaomeriti]

Great Vídeo Joe!
Please, prepare a video using LB10 transaction to stract report from it.

[Piier]

Hi Joel. Amazing videos, you helped me a lot. Is possible to have a tutorial for saving pdf files from an adobe crobat window open in sap?

[bunbunai]

Hi Joel, great stuff! I am wondering about saving pdf files from SAP though. I've tried your code up till a save window pops up, but have no idea how to automate inputing the file names from a sheet column and then selecting the save button. Could you suggest me on this?

[ibrahimmib]

Hi Jo, You are rocking.... learned lot awesome.

How to loop particular Sap steps in vba? Would be good to know that please

[hamadasalah]

Hello Joel, Thank you for your informative video. Do you have any video "How to import data into SAP?".
I have time records in Excel sheet, and I want to import it to SAP instead of inserting it one by one using "CAT2".

[vijayj]

Thank you this worked👌.... how can this be done for multiple report from different t-code

[maheshchagi]

Hello,
I was trying to loop the data but getting an error message (followed your steps still count not get loop)

[kpk]

You Got a new
You are an inspiration to people who are lazy on repeated report extraction all the time..😜 and excited to improve productivity and save time🦾🦾

[yanhirata]

Thank you, Joel! Is it possible to save all results in 1 file, instead of the separate paths?

[seandavis]

Hi Joel, thanks for the videos, as a complete beginner this has taught me a lot already. I have one question though, how to close all instances of Excel, it only seems to close one instance (The original one with the three rows of countries in your case). Since I have created 3 reports like yourself, I have all three created ones left open. Even with the code at the end

[MrsKee-qugc]

Hi Joel, thanks for this video. Do you have a code to export data from SAP to same VBA file but different tabs? Would really appreciate your comment