Hello.

Is there a simple way to create an Excel macro library? Basically, I just
want to store a number of macros in a module behind a workbook and have the
public functions therein be available to be called from any other workbook
that I happen to have open. (For clarity, I DO NOT want to duplicate code
into each workbook in which I need the relevant function.)

For now, I would like to avoid creating a proper add-in using the .net
framework.

Can I achieve my goal by creating an xlam file and including a reference to
it from any workbook ? Or is there another simple approach?

Thank you.

Keith

If it used on just your machine, use the "Personal Macro Workbook" which is
created the first time you record and save to this option. This workbook,
if it exists, is silently opened (remains hidden) with Excel and its modules
and code can be used in your other workbooks in the session. Take care with
naming conventions!

--

Regards,
Nigel




"Keith Howard" wrote in message
...
Hello.

Is there a simple way to create an Excel macro library? Basically, I just
want to store a number of macros in a module behind a workbook and have
the
public functions therein be available to be called from any other
workbook
that I happen to have open. (For clarity, I DO NOT want to duplicate code
into each workbook in which I need the relevant function.)

For now, I would like to avoid creating a proper add-in using the .net
framework.

Can I achieve my goal by creating an xlam file and including a reference
to
it from any workbook ? Or is there another simple approach?

Thank you.

Keith

On Thu, 2 Apr 2009 03:41:36 -0700, Keith Howard
wrote:

Can I achieve my goal by creating an xlam file and including a reference to
it from any workbook ?

Yes, and that is what I do.
--ron

Excel Add-In do not require .NET Framework.

http://www.ozgrid.com/VBA/excel-add-in-create.htm

If this post helps click Yes
---------------
Jacob Skaria


"Keith Howard" wrote:

Hello.

Is there a simple way to create an Excel macro library? Basically, I just
want to store a number of macros in a module behind a workbook and have the
public functions therein be available to be called from any other workbook
that I happen to have open. (For clarity, I DO NOT want to duplicate code
into each workbook in which I need the relevant function.)

For now, I would like to avoid creating a proper add-in using the .net
framework.

Can I achieve my goal by creating an xlam file and including a reference to
it from any workbook ? Or is there another simple approach?

Thank you.

Keith

Try this one for 2007
http://www.rondebruin.nl/qat.htm

Very easy to create a nice menu

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Keith Howard" wrote in message ...
Hello.

Is there a simple way to create an Excel macro library? Basically, I just
want to store a number of macros in a module behind a workbook and have the
public functions therein be available to be called from any other workbook
that I happen to have open. (For clarity, I DO NOT want to duplicate code
into each workbook in which I need the relevant function.)

For now, I would like to avoid creating a proper add-in using the .net
framework.

Can I achieve my goal by creating an xlam file and including a reference to
it from any workbook ? Or is there another simple approach?

Thank you.

Keith