I have written several modules and forms that combine to provide a complete
solution to a problem within our business, but I need to have these modules
and forms available within hundreds of files which I then mail out to users
within the company.

So far I have been dragging and dropping the relevant modules into the excel
documents manually.

Is there a simple way (add ins maybe) that will allow me to achieve the same
result in and automated fashion???

hi
have a look at this site. it has a section about copying a module from one
project to another
http://www.cpearson.com/excel/vbe.aspx


regards
FSt1

"JLR-Mart" wrote:

I have written several modules and forms that combine to provide a complete
solution to a problem within our business, but I need to have these modules
and forms available within hundreds of files which I then mail out to users
within the company.

So far I have been dragging and dropping the relevant modules into the excel
documents manually.

Is there a simple way (add ins maybe) that will allow me to achieve the same
result in and automated fashion???

You could create an xla (add in) which you can package off or you can
add code by code, take a look at Chip Pearsons site, there is coe ther
which is very well laid out and explained.

JLR-Mart;261485 Wrote:
I have written several modules and forms that combine to provide a
complete
solution to a problem within our business, but I need to have these
modules
and forms available within hundreds of files which I then mail out to
users
within the company.

So far I have been dragging and dropping the relevant modules into the
excel
documents manually.

Is there a simple way (add ins maybe) that will allow me to achieve the
same
result in and automated fashion???


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72960