Using TransferSpreadsheet method, use each query's name as the "exported
table/query", and use the same path/filename to the EXCEL file for each
export.
Look in Accesss Help for TransferSpreadsheet. Whether you use the Action
for a macro or the Method for the Docmd object using VBA, there is an
argument that you can use to specify the sheetname.
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.
