Excel VBA pulling data from SAP NetWeaver

How do you pull data from SAP NetWeaver into Excel using a VBA macro?

I have data in an SAP system accessible in a few different transactions through the SAP GUI. I need to extract this data on a daily basis, then format it into Excel spreadsheets and reports. Manually extracting this data is very time consuming and error prone.

I don’t have developer or system support. I have to be able to do it myself as an unprivileged user.

Hi there,

To extract the data, I think you can use writeToCSV or appendToCSV command. If you go to Sample Projects within Katalon Recorder, you’d see a couple of sample projects that show you how to do that.

I suggest trying to use these commands and then follow up with any issue that prevents you from doing it.