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

In today's video I will show you how to combine SAP GUI Script and Excel macros with each other. Very handy for users who regularly export data from SAP to Excel. We select different data and save them in separate Excel files. The whole thing happens with a script and a loop.

#sap #excel #vba #export

▬▬ Literature 📚 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Hardware 💻 ▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ My Software (free) 💾 ▬▬▬▬▬▬▬▬▬▬▬

▬▬ Further Links 🔗 ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

*The links are affiliate links. There are no additional costs.

Microsoft excel icons created by Pixel perfect - Flaticon
Sap icons created by Freepik - Flaticon
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

[pramodpandey]

Very helpful for every user. Thank you so much

[daminifutane]

Big help for me, thanks a lot, keep bringing more content, any possibility that output sheets could be made part of same workbook?

[iougpjz]

Great content bro, very helpful. how do i export SAP data onto the Macro enable spreadsheet, and not on the new sheet?

[marthareyes]

This is so helpful, saving a lot of time!!!! What do I need to do for the excel files to get closed. Using this code for over 50 files downloads.

[kamilagirona]

how can I automate download attached files related to doc SAP number? I did a scripting but I coudn't connect with file path where I would like to save files in my windows

[Digitor]

This tool is exceptionally handy, and I am curious if it offers the capability to generate reports for different months. Can you please provide some examples of how to modify the date and run the report via Macro setting?

[jellyacecream]

hi, can you tell me how to close the workbooks opened after the extract from SAP? I'm running a different excel file in the next step where the extracted files are referenced. thanks

workbook.(filename).close at the end of the macro is showing a runtime error

[andyjohnson]

Nice but what to do if you have no authorization to run se16? I need download fse5n reports for each cocode…

[dawidpe]

@CustAndCode could you make a video or help me what can i do in situation like in 4:31 on upper video but in my situation i want 1 report for all carryid from column A? i got over 10 carryid. big thank you for your helping.

[xuanthutran]

Thank you so much! So how can I automatically close opened excel files in this way? Pls show me!

[MaheshKumar-drxk]

Bro can we create for background executed extraction

[gabrielasiqueira]

Hi,
When some users are saving the file opens the name and path window and others opens only the explorer window so the Macro stops. How to configure to show only the name and path window before saving?

[mihais]

Does someone know why i receive this error " application defined or object defined error" for line lastRow = ThisWorkbook.Sheets("Sheet1").Cells(Rows.Count, 1).End(x1Up).Row

[mrunavailable]

So I do this for work, but I use to have that window that asks for Directory and file name, but I changed my layout and now it opens a file explorer how can i change that?

[nagukanuri]

Hello sir im getting error in last row im stuck with that. can you help me on this

[christophwissing]

It would be possible to run the Skripts automatically to every hour each day ?

[srqwnz]

Hello!
I need some help. :) :(
Whatever folder path I add, I got error: runtime error 619 the control could not be found by id (Folder is already created!)
And in Watchlist below the coding field: <Expression not defined in context>
=
= "xyz.xlsx"


Thanks a lot!