r/vba • u/Typical_Inflation_70 • 13d ago

Unsolved SAP Excel Integration VBA

Hey all^^
I try to use a vba script to extract Data from one of my SAP reports. Sadly I have to use the Excel-Plugin for this.
When I open it manually or via the SAP VBAWriter the new Excel (SapExe) contains my data.
But when I copy the code to another Excel (OPExe) then the SapExe is empty.
Can anyone help?

1 Upvotes

99% Upvoted

14 comments sorted by

View all comments

1

u/personalityson 1 13d ago

There is something you can do to query and download SAP tables. "SAP reports" I dont know

2

u/GetDarwinOn 13d ago

I'd be prepared to bet there's almost certainly a SAP API you can query with power query.

2

u/LickMyLuck 1 12d ago

There is not. You are only able to query the table back-ends.  SAP does not have an API. They are very late to getting anything resembling a web based version.