Output to : Template file

  • Thread starter Thread starter Roger
  • Start date Start date
R

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
 
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
 
Back
Top