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.