Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Using VBA for loading Query data into Excel workbook

Hi all.

I want simply load data from BEx query into Excel Wortksheet using VBA because of report formats and footer section at the end of the results.

Any code examples, tutorials, comments, suggestions will be regarded.

thanx in advance,

Gediminas

Former Member
Former Member replied

There is a special VBA sub called after refreshing of the query in a workbook, SAPBExOnRefresh in BW 3.x, Callback in BI 7.0 (not sure of the name), and you can code VBa in it to reformat the resultarea.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question