Transfer Multiple Queries to Same Excel Workbook

[brittain12]

Yes, i am needing some help! I am an access novice and know i se this database up wrong, but need to see if someone can help me on transfering data out. This is what I have

- 15 different training queries that have different data in them (all the headings are the same in each query)
- I want to be able to click a button and a macro to be able to send all the queries to the same excel document.
- My 15 different queries are "Training1Exp" all the way to "Training15Exp"

Is this possible?

[alansidman]

This might be helpful. You will have to repeat the docmd for each query within your vba code.

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

[brittain12]

I have no idea on how to create code, where do i input this at? and when i go to create a macro "transferspreadsheet is not a choce to pic from

[alansidman]

I am not familiar with the ins and outs of Macros in Access. They are not the same as VBA. Without details of your situation, one cannot write your code for you. Basically, you will need to put a command button on a Form, create code that uses the TransferSpreadsheet functionality 15 times when the button is created. If you wish to explain in simple English the details of what you want, then someone here may be willing to write the code for you.

ie. Names of each of the queries, location that the queries should go, Spreadsheet name, Path to the spreadsheet, each query on a different sheet of your workbook or all on one sheet. Lots of variables here that only you know.

[ssanfu]

If you wish to explain in simple English the details of what you want, then someone here may be willing to write the code for you.

I understand the OP might not understand VBA, but take a look at:
Ken's Examples for Exporting to EXCEL Workbook Files
http://www.accessmvp.com/kdsnell/EXCEL_Export.htm

See the third option:
Create a Query and Export multiple "filtered" versions of a Query (based on data in another table) to separate Worksheets within one EXCEL file via TransferSpreadsheet (VBA)
http://www.accessmvp.com/kdsnell/EXC...ExportSameFile