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

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

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?

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

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

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

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?

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

Thanks!

This is so helpful. Thank you so much

Thank you 🎉🎉🎉

creative as usual.