macro that outputs queries to excel

G

Guest

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Multiple Queries to the same Excel File 4
Output to : Template file 3
help VBA code in macro 2
Stop macro after selecting 'no' 0
Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
how do you send multiple queries in a macro to an email? 1
Output to macro action 1
Is possible TranferText action with parametr in query 1

Top