macro that outputs queries to excel

[Lori]

Is it possible for a macro to output multiple queries to a certain sheet in
an excel file?

 

[Steve Schapel]

Lori,

I assume the structure of the "multipole queries" is the same. In his
case, make a Union Query comprising all the existing queries. And then
use a TransferSpreadsheet macdro, or OutputTo macro, to export the data
from the Union Query to Excel.