The above two methods are the only ones we have for building a multiple query - single Excel export report. That and the use of macros.
To summarize, here are the methods.
- Put all queries into a script and use the Add Query Export wizard.
select * from a;
select * from b;
select * from c;
When exported the result from each query will be put into a new worksheet starting at the upper leftmost cell and row.
- Export a single query to a specific worksheet name, starting cell, or named region.
Here you can use the add query in Export. In the configuration page choose an existing named range, or named worked sheet, or select a specific cell/row to place the data.
- For additional formatting you will need to add a Macro. The macro can be called before or after the export.
Between these three methods it covers most needs.
Let me know if you need more help on this. If so, you will probably need to post some examples so I can get more detail on what you want to accomplish.