Hi, I have created two files:
1. MacroLibrary.xlam
2. InvokeMacroFromLibrary.xlsm

MacroLibrary.xlam has a simple HelloWorld function.
InvokeMacroFromLibrary.xlsm has a simple Welcome function.


I want to be able to invoke HelloWorld function (present in
MacroLibrary.xlam) from InvokeMacroFromLibrary.xlsm and use the same.

Alternatively, I want to be able to use both the functions in a sequence one
after the other. Something like the following
Function/Sub Third_Function()
'Call HelloWorld()
'Call Welcome()
End Function/Sub

How can I do so?

In the Invoke workbook's VBA Project, set a reference to the XLAM VBA
Project. You should change the name of the XLAM project from the
default "VBAProject" to something more meaningful.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 7 Apr 2009 08:18:10 -0700, Keith Howard
<(E-Mail Removed)> wrote:

>Hi, I have created two files:
>1. MacroLibrary.xlam
>2. InvokeMacroFromLibrary.xlsm
>
>MacroLibrary.xlam has a simple HelloWorld function.
>InvokeMacroFromLibrary.xlsm has a simple Welcome function.
>
>
>I want to be able to invoke HelloWorld function (present in
>MacroLibrary.xlam) from InvokeMacroFromLibrary.xlsm and use the same.
>
>Alternatively, I want to be able to use both the functions in a sequence one
>after the other. Something like the following
>Function/Sub Third_Function()
> 'Call HelloWorld()
> 'Call Welcome()
>End Function/Sub
>
>How can I do so?