export from access query to excel template

[Ivanl]

Hello,

I have used the transferspreadsheet to transfer the data from the query I
want to excel. That works fine.

The problem is, I want the data from excel to be placed into a template
file. e.g. when you double click on a template file, a template opens, and
the data should go in there.

As it stands now, the transferspreadshet puts the data into the template as
if I clicked "open" and put the data it.

How do I transfer the data to a template as if I double clicked on the
template file?

Thanks,

Ivan

 

[arookie]

You will need to use the excel object and then open the worksheet,
open the query in recordset, loop thru the recordset and then fill the
data in worksheet range, save the file using application path and then
open it for user.