Outputting to a template

[dan]

Hi,

I am trying to ouput a queries output into an excel
template but Outputto doesn't have for using templates
for excel. Is there another way to output the queries
output into a template?


Thanks.

 

[John Nurick]

Hi Dan,

You can do this by using Automation to launch Excel, and open a copy of
the template. Then create a recordset on your query and use Excel's
Range.CopyFromRecordset method to place the data where you want it.

There's an example of basic Excel automation here:
http://www.mvps.org/access/modules/mdl0006.htm