Exporting Table to Specific Excel Worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 14 Mar 2008 17:19 GMT

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.

Signature

Bob

Reply to this Message

Jeanette Cunningham - 15 Mar 2008 06:25 GMT

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

>I have a macro that opens a query, runs the app and then transfers the
>table
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

Chris - 25 Mar 2008 21:16 GMT

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

> Bob,
> You can use TransferSpreadsheet to export to an existing, formatted excel
[quoted text clipped - 16 lines]
> >
> > Thanks.

Reply to this Message