in the last time I occupy oneself with BW and BEx to automate querys. I think there are two ways to save an Excel-Workbook:
1. you can save it as workbook in the InfoCatalog (saveoption in the BEx toolbar)
2. or save it classical as .xls by Excel
Now my question: there are any reasons against Variant 2? I find its a little easier to write only one Excel-Workbook-Macro. For Variant 1 I need 2 Workbooks, one Autostart-Workbook that opens the sapbex.xla and the second Workbook from the InfoCatalog.
Is the choice only a matter of taste?
Message was edited by: