exporting queries to spreadsheet tabs

[msfirsttrust]

I have 11 queries I need to export to a spreadsheet. Is it possible to use the Output To function in a macro to export each query to a tab in the spreadsheet, rather than each query to its own sheet?

 

[Joe4]

From what I have seen over the years, it is possible, but it looks like it requires VBA (I have never seen it done without VBA code).

A Google search of the internet brought up a lot of code. Here is one that looks like fits pretty good (though there are others out there also):
http://www.access-programmers.co.uk/forums/archive/index.php/t-51541.html