Exporting Query results to Excel with VBA

[Tomlon]

I have a collection of queries that I need to export to Excel using VBA (From Access 2010 to compatible files for Excel 2007/2010). I would like each query to be placed in a newly created workbook in seperate worksheets (again, all in same workbook). Something similar to this:

Query1 - Into Worksheet labled Query1
Query2 - Into Worksheet labled query2
Query3 - Into Worksheet labeled query3



So, with a click, I would like to have a Workbook created and the queries inserted into these worksheets. Any help is appreciated.

[alansidman]

This link should be helpful

http://accessblog.net/2006/07/export...cel-range.html

Alan