Macro updates
 

I have 17 workbooks that operate with the samemacros and formulas although
they contain different data.
The problem is with updating the macros. I must import any change 17
different times.
Is there a way that I could have a central macro repository and have all of
the 17 workbooks use the central macro?

Glen

Macro updates
 

Use an addin and maybe create a menu to run the macros from.

Creating an addin is very simple.


Open a new workbook and setup your code in that new workbook (you need to
make sure that you code is flexible enough to work in a different workbook
than the hosting workbook, but that is probably another story).


The save the workbook as an add-in. Addins are a workbook type, you should
find it at the bottom of the list of file types. Beware, as soon as you pick
addins, Excel will try and direct the save directory, so be doubly sure it
is where you want.

Once saved, close the workbook, and then install tghe add-in by going to
menu ToolsAddins and then click the browse button and go find the file.
You will then see an entry in the list of addins and it will be checked.
Every time Excel starts in future that add-in will be loaded. So you can
change it, and next time, the changes will be picked up.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glen Mettler" wrote in message
.. .
I have 17 workbooks that operate with the samemacros and formulas although
they contain different data.
The problem is with updating the macros. I must import any change 17
different times.
Is there a way that I could have a central macro repository and have all
of
the 17 workbooks use the central macro?

Glen

Macro updates
 

Thanks Bob. I think that is just what I need.

Glen
"Bob Phillips" wrote in message
...
Use an addin and maybe create a menu to run the macros from.

Creating an addin is very simple.


Open a new workbook and setup your code in that new workbook (you need to
make sure that you code is flexible enough to work in a different workbook
than the hosting workbook, but that is probably another story).


The save the workbook as an add-in. Addins are a workbook type, you should
find it at the bottom of the list of file types. Beware, as soon as you
pick
addins, Excel will try and direct the save directory, so be doubly sure it
is where you want.

Once saved, close the workbook, and then install tghe add-in by going to
menu ToolsAddins and then click the browse button and go find the file.
You will then see an entry in the list of addins and it will be checked.
Every time Excel starts in future that add-in will be loaded. So you can
change it, and next time, the changes will be picked up.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glen Mettler" wrote in message
.. .
I have 17 workbooks that operate with the samemacros and formulas
although
they contain different data.
The problem is with updating the macros. I must import any change 17
different times.
Is there a way that I could have a central macro repository and have all
of
the 17 workbooks use the central macro?

Glen

Macro updates
 

If you need help with creating the menus, just post back.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glen Mettler" wrote in message
...
Thanks Bob. I think that is just what I need.

Glen
"Bob Phillips" wrote in message
...
Use an addin and maybe create a menu to run the macros from.

Creating an addin is very simple.


Open a new workbook and setup your code in that new workbook (you need
to
make sure that you code is flexible enough to work in a different
workbook
than the hosting workbook, but that is probably another story).


The save the workbook as an add-in. Addins are a workbook type, you
should
find it at the bottom of the list of file types. Beware, as soon as you
pick
addins, Excel will try and direct the save directory, so be doubly sure
it
is where you want.

Once saved, close the workbook, and then install tghe add-in by going to
menu ToolsAddins and then click the browse button and go find the
file.
You will then see an entry in the list of addins and it will be checked.
Every time Excel starts in future that add-in will be loaded. So you can
change it, and next time, the changes will be picked up.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Glen Mettler" wrote in message
.. .
I have 17 workbooks that operate with the samemacros and formulas
although
they contain different data.
The problem is with updating the macros. I must import any change 17
different times.
Is there a way that I could have a central macro repository and have
all
of
the 17 workbooks use the central macro?

Glen