Using VBA for loading Query data into Excel workbook

[Former Member]

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 · Accepted solution]

Why not just format the BEx analyser workbook template with headers and footers?

[Former Member · Accepted solution]

The difficalty is that I don't know the number of rows report will return. And I need my footer only on LAST page of workbook.

Another thing I can't imagine how to do by using standart BEx functionality is to design complex column header set (merged columns, sub-columns and etc.).

[Former Member · Accepted solution]

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.