fourty different spreadsheets with the same macros

[daniroy]

I have setup a model spreadsheet with a number of source datas sheets
and a number of results sheets.
I go from the source datas sheets to the results sheets through a
number of macros.

I need to setup 40 different spredsheets all on the same model, on
different industries, thus using 40 different sources datas sheets but
always respecting the same model, and on thus I can which the same
macros.

I obviously can do 40 copy and paste, and change the datas sources,
what I have done.

I thus have the same code on all the 40 spreadsheet, but what if:
.. I change the code on my first spreadsheet to setup a new results
sheet? I will have to ammend the code on the 40 and so other
spreadsheets. Not very convenient to say the least, especially as the
40 could be 120 in the future.
I have vaguely heard about .xla. Is that the solution?
Can anybody help? It would be deeply appreciated as it is the limit of
my abilities on VB...
Kind regards and merry Xmas to everybody
Daniel

 

[daniroy]

Yep add-ins and xla are exactly what I am looking for,
so I have created a .xla with the macros I want to use,
but I cannot call them from another spreadsheet, why is that?
As I had the same kind of macros in the second spreadsheet, I removed
all the modules, but how to know call them from the .xla??
Thank you
Daniel

 

[daniroy]

found it
http://www.fontstuff.com/vba/vbatut08.htm
tks
Dan

 

[daniroy]

not very convenient, is it? as if you have 120 files you must refer 120
times?
Isn it possible to code something up?
Kind regards
Daniel

 

[daniroy]

but you got to manually refer to the add-in in the Microsoft Visual
Basic of the "daughter" spreadsheet, havent you?