Splitting data into multiple tabs with VBA - Interacting with Exported Excel Spreadsheet from SAP

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 interact with the Excel spreadsheet exported from SAP and apply some steps to format and edit the spreadsheet based on your likings. All these can be done within a single process, which can saves you a lot of time.

Timestamps
00:00 Introduction
00:19 Overview of SAP Scripting and End Goal
00:56 Using function to obtain file directory
01:17 Building process to split exported data into multiple tabs
05:01 End result and Conclusion

#SAPScripting #ExcelSAPAutomation #SAPExcelIntegration #SAPVBA

DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.

I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.

WORKING 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:

[AmirHazwan]

Keep it up Joel! Thanks for the videos!

[worapon]

This is massive helpful videos for my job. Thank you very much for your sharing.

[naiduvikas]

Excellent💯💯👏👏👏👏 I really love your sap GUI scripting videos. Please do more videos on SAP GUI SCRIPTING
From :India 🇮🇳 Hyderabad

[titoyudatama]

Thank you very much, nice info!! I've subscribed you, keep the spirit for the next videos

[abhishekchavan]

Nice stuff Joel 👍👍 I am working on Sap ECC 6 version and now working on a Journal posting template in FICO. Any suggestions ? I can't use manual postings as an option as we post entries with more than 700 - 800 rows ...

[limadidaslcy]

hi Joel, thank for your sharing, I found your video is really helpful for me.
would like to ask, if i extracted data from SAP, and my excel is automatically open. If it is possible, i want to continue in the workbook to remove the apostrophe symbol from the data number display from SAP?

[santhukail]

Hi Joel, can we automate the system to capture the SAP screen prints to excel file?

[ollytv]

Hi Joel, please make a video on how to automate drag and drop using sap gui? My problem is whenever the box in FB03 appear where I save my attachment, hitlist is not working so I have to maually click the attachment and hit enter.

[giogobronidze]

Thanks for the video. I see that you have the option to get the extract in xlsx format but I dont. You have explained in of your videos but I dont really have that option. Is there something else I could do ?

[vishalrajbhar]

Hi Joel..

How can close the workbooks after export data from SAP . Bcz it’s showing run time error 91 ( Out of the script ) while workbooks already open and VBA code doesn’t work pls help.

[muhammaddanish]

Make a playlist of SAP FICO module tutorial

[MKEWSH]

When exporting out of SAP, the excel file will automatically open after it exports. I need my script to wait for the export to open, and then to close the newly opened export file. If I try to activate the export file immediately following the command to export the file in SAP GUI, I get a "subscript out of range" error. I thought maybe I could loop the activate command until it stops erroring (while the export.xlsx file is opening) but that causes excel to crash. I also tried using a delay, using application.wait but the download hangs no matter what time I input into the delay; 5 seconds, 15 seconds, it doesn’t matter. Manually, when exporting, it opens in about 3 seconds. Having said that, when the error pops up, it triggers the export to immediately open. Seems like when scripting, SAP doesn’t have the ability to recognize the export. When I step through the code manually, I don’t have any issues activating the export after it downloads and automatically opens. I’m not sure what to do here, any suggestions?

[gouravdeshmukh]

Hey joel how can we script if we want to take a Screenshot

[demcjqq]

How can I close the exported excel file ? Because it opens automatically after the extraction .Any tips