Macro in Template needs to go to XLS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

2D Rick - 14 Sep 2006 19:04 GMT

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

Reply to this Message

Huff - 18 Sep 2006 16:03 GMT

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

> I use Docmd.OutputTo in Access2003 to send the data from a report to
> Excel.
[quoted text clipped - 5 lines]
>
> Thanks, Rick

Reply to this Message