Using VBA for loading Query data into Excel workbook
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,
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.