Output to : Template file

[Roger]

I have an Access macro which outputs data from a query to an excel xls file.
I want to use an xls template with a excel macro in it to analyse and format
the data output. However, the access macro always creates a new xls file,
can I use the template file feature in the access macro so that it always
uses the same xls file (containing the excel macro I want to use) ? I am
using Access 2002 SP3 and Excel 2002 SP3 on XP

thanks .. Roger

 

[Ken Snell]

Try using TransferSpreadsheet instead of OutputTo.

 

[Roger]

Thanks, I have had a look at TransferSpreadsheet and I notice it wants a
name of a table to export from, will it work with exporting from a query as
well ?
.... Roger

 

[Ken Snell]

Yes, it will export a table or a query.