I have several excel files which are all identical in what they do but
all contain different data (each one is a different year) and they
have to remain separate files. Using a script in a module it populates
each sheet. Works great but the problem is that the modules in all of
the files are identical and whenever i need to change the code, i have
to go into each file and copy/paste the new code in. To run the code
each sheet has a button which activated Sub Populate() in the code. Is
there a way for me to put the code into a separate file in a different
location so that the can all share the same code?

Thanks!

hi
yes. put the code in a personal.xls file and put the file in the xlstart
folder so that it will open when excel opens. the personal.xls file is
usually hidden but all macro in the personal.xls file are available for any
file. many users put their personal UDF in thier personal.xls also.

regards
FSt1

"(E-Mail Removed)" wrote:

> I have several excel files which are all identical in what they do but
> all contain different data (each one is a different year) and they
> have to remain separate files. Using a script in a module it populates
> each sheet. Works great but the problem is that the modules in all of
> the files are identical and whenever i need to change the code, i have
> to go into each file and copy/paste the new code in. To run the code
> each sheet has a button which activated Sub Populate() in the code. Is
> there a way for me to put the code into a separate file in a different
> location so that the can all share the same code?
>
> Thanks!
>