Exporting Access Query data into existing Excel Workbook?

[sagain2k]

I have a macro that currently exports a query into a new Excel workbook with a given path and name. How can you tell it to export (insert) into an exisitng Excel workbook instead? Here's the current code that from within Access creates an Excel file with the Query data in it:

DoCmd.OutputTo acQuery, "qryCourseScheduleRpt", "MicrosoftExcel(*.xls)", _
"q:\qryResults\EngCourseSched.xls", True, ""

What I want is to be able to have a template Excel workbook that any query can be exported into (and that template Excel workbook will have macros associated with it that can then format the imported query data.

Thanks for any suggestions!

 

[Norie]

Change from using OutputTo to TransferSpreadsheet.

eg

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "Exclusions", "C:\PPI\Exclusions.xls!Sheet1"

This exports the query/table Exclusions to an already existing Excel workbook called Exclusions.xls which is in C:\PPI.

BTW the query is imported into a new worksheet called Exclusions, something which you will need to consider for the Excel formatting.