Is it possible for a macro to output multiple queries to a certain sheet in an excel file?
L Lori Aug 29, 2007 #1 Is it possible for a macro to output multiple queries to a certain sheet in an excel file?
S Steve Schapel Aug 29, 2007 #2 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.
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.
