Macro in Template needs to go to XLS

[2D Rick]

I use Docmd.OutputTo in Access2003 to send the data from a report to
Excel.
I tell it to use a Template which has 1 macro assigned to it.
The OutputTo function saves it as a XLS file but the macro doesn't make
it to the new file.
Why, and is there something that will pass the macro from the template
to the XLS????

Thanks, Rick

 

[Huff]

Rick

I've used the DoCmd.TransferSpreadsheet method to write data from a
query to a spreadsheet that has an AutoOpen macro on it. This method
seems to work fine and the macro runs.

Not certain if that's exactly what you're looking for or not, but may
be a start.

Thanks

D