2 Queries Export to Excel in the same spreadsheet

[Eddy]

I would like to export the output of 2 queries to excel namely:

1. QryProrationbyW BS_1
2. QryProrationbyW BS_2

However I want to do this using the same spreadsheet say sheet1 and
sheet2 or better still with sheet name "ProrationW BS1" and
"ProrationWBS2" , how do I do this with acOutputQuery

I have the following 2 commands attached to a command button:
1) DoCmd.OutputTo acOutputQuery, "QryProrationby WBS_1", acFormatXLS,
"C:\Documen ts and Settings\All Users\Desktop\C onsumbles Report.xls",
False
2) DoCmd.OutputTo acOutputQuery, "QryProrationby WBS_2", acFormatXLS,
"C:\Documen ts and Settings\All Users\Desktop\C onsumbles Report.xls",
False

How do I combine both of the above outputs such that they both come on
a single spreadsheet

Many thanks for your help in advance
Edward

[ADezii]

I would like to export the output of 2 queries to excel namely:

1. QryProrationbyW BS_1
2. QryProrationbyW BS_2

However I want to do this using the same spreadsheet say sheet1 and
sheet2 or better still with sheet name "ProrationW BS1" and
"ProrationWBS2" , how do I do this with acOutputQuery

I have the following 2 commands attached to a command button:
1) DoCmd.OutputTo acOutputQuery, "QryProrationby WBS_1", acFormatXLS,
"C:\Documen ts and Settings\All Users\Desktop\C onsumbles Report.xls",
False
2) DoCmd.OutputTo acOutputQuery, "QryProrationby WBS_2", acFormatXLS,
"C:\Documen ts and Settings\All Users\Desktop\C onsumbles Report.xls",
False

How do I combine both of the above outputs such that they both come on
a single spreadsheet

Many thanks for your help in advance
Edward

What you are describing can quite easily be implemented within Excel, not
Access, and possibly automated via an Excel Macro. Here it goes:
01) Select cell A1 in Excel
02) Select the Data Menu
03) Select Import External Data
04) Select Import Data
05) Select you Data Source (YourDatabase.m db)
06) Select qryProbationWBS _1
07) Go
08) Make sure Existing Worksheet is selected with Cell = $A$1
09) Import Data
10) Repeate the process for qryProbationWBS _2 but with a different
starting Cell location. e.g. =$A$200

Hope this helps

[Gord]

>How do I combine both of the above outputs such that they

both come on a single spreadsheet

DoCmd.TransferS preadsheet will do that for you, e.g.

DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, _
"Query1", "d:\foo.xls "

[Eddy]

Thanks, it worked