--
Jeff C
Live Well .. Be Happy In All You Do


"Tim Zych" wrote:

Can you leave a blank workbook template with a macro on the network and
start with that? Instead of creating it, copy it.

In this case I am not able to do that, I was hoping that there was a way to
leave a function/macro some way in the particular system where the process
was running so that every new workbook created by that system would include
the macro.


--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"Jeff C" wrote in message
...
I have a function that creates new custom workbooks for each client and
distributes them across a network.

How can I get a macro automatically placed in the OnOpen event of each new
workbook when it is generated?

The workbooks are generated from the transferspreadsheet function in
Access
using Win XP Pro and Office 2003.

Thanks in advance

--
Jeff C
Live Well .. Be Happy In All You Do