Replicate VBA code to multiple files

[Guest]

I have some VBA code contained in Excel file modules. I want to replicate the
changes that I make to the code to the other files, without having to open
each file and having to, copy and paste over write, what is already in there.
The other files also use the same code.

In MS project I had seen that there is a Global template which can contain
code and can be accessed by a custom tool bar button. This code is available
to any file that is intended to be used with the code, without having the
code resident within the project .mpp file.

How do I do this. I vaguley remember seeing this some time ago. But am not
able to figure out where it is. The help does not show anthing either.

Can some one please help.

 

[Guest]

Closest you would come would be to create an Addin or if it is only for you,
you could put it in your personal.xls file. However, you can not directly
call those functions from those workbooks as if they were resident unless you
create a reference to the addin or personal.xls. You can use application.run
when you don't have a reference.

you also might look at http://www.cpearson.com/excel/vbe.htm for your
existing problem.

 

[Guest]

--
Sajit
Abu Dhabi

Closest you would come would be to create an Addin or if it is only for you,
you could put it in your personal.xls file. However, you can not directly
call those functions from those workbooks as if they were resident unless you
create a reference to the addin or personal.xls. You can use application.run
when you don't have a reference.

you also might look at http://www.cpearson.com/excel/vbe.htm for your
existing problem.