Skip to Content
Actions

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

Using VBA for loading Query data into Excel workbook

This question is answered

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

September 12, 2008 at 10:03 AM
0 Likes
Correct Answer
replied
September 12, 2008 at 10:03 AM

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 Likes 0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question

3 replies