Exporting Table to Specific Excel Worksheet

[Bob]

I have a macro that opens a query, runs the app and then transfers the table
to Excel. Is there a way to transfer the table to a specific tab in my Excel
sheet and and to a specific cell in the worksheet. For example I would like
my access table transferred to the Jones tab in the IS file and would like
the data to begin in cell "A6"

Thanks.

 

[Jeanette Cunningham]

Bob,
You can use TransferSpreadsheet to export to an existing, formatted excel
spreadsheet by careful, limited use of the "Range" argument. Details on
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

If you want the export to start in A6, automation using the excel method
called Copy From Recordset is needed.

Jeanette Cunningham

 

[Chris]

Bob,

How did you get the whole list of Macros to run. I wrote three lines of
macro and it only runs the first one. Is there a call function for the second
one? I want to automate the query to be exported into excel.

Chris