I have a script that I run the formats a bunch of data and copies 5 sheets
and puts them in a new work book. I want to add an autorun module to this
new book. I'm not sure if it is easier to add the module from scratch or
copy it, but I want the module to be there when the other code I have saves
the new work book.

Can anyone offer any suggestions?

thanks!
Mark

You might find the following web page of interest:

http://www.cpearson.com/excel/vbe.aspx

"Mark" wrote:

> I have a script that I run the formats a bunch of data and copies 5 sheets
> and puts them in a new work book. I want to add an autorun module to this
> new book. I'm not sure if it is easier to add the module from scratch or
> copy it, but I want the module to be there when the other code I have saves
> the new work book.
>
> Can anyone offer any suggestions?
>
> thanks!
> Mark

Create a template file with the code, layouts etc already in-situ. Then
when creating a new workbook use the template.

--

Regards,
Nigel
(E-Mail Removed)



"Mark" <(E-Mail Removed)> wrote in message
news:C55DB625-3FA5-46A1-9F0F-(E-Mail Removed)...
>I have a script that I run the formats a bunch of data and copies 5 sheets
> and puts them in a new work book. I want to add an autorun module to this
> new book. I'm not sure if it is easier to add the module from scratch or
> copy it, but I want the module to be there when the other code I have
> saves
> the new work book.
>
> Can anyone offer any suggestions?
>
> thanks!
> Mark

Mark wrote:
> I have a script that I run the formats a bunch of data and copies 5 sheets
> and puts them in a new work book. I want to add an autorun module to this
> new book. I'm not sure if it is easier to add the module from scratch or
> copy it, but I want the module to be there when the other code I have saves
> the new work book.
>
> Can anyone offer any suggestions?
>
> thanks!
> Mark

Make an excel addin that contains your module. That way the module is
available to all workbooks as long as the addin is selected in excel.

P