Macro question

[cornishteeth]

I have created a macro that transfers my queries to a spreadsheet. I have a total of 12 queries based on date inputs and utilize the TransferSpreadsheet option. This works just fine, but I would now like to refine the output. When I open the Excel file it has created 12 different spreadsheets. The data contained is quite minimal (usually 1 to 10 rows by 2 columns.) How can I put all the data on one single spreadsheet and not 12? Thanks in advance for your help.

Cornishteeth

 

[Dugantrain]

Look under the Help Files for the TransferSpreadsheet method. The code that you would customize is the exact same code that the Macro writes for you, only you have more control. You can specify Worksheet and Range properties here.