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!
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!