View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Howard Keith Howard is offline
external usenet poster
 
Posts: 14
Default Add-ins in Microsoft excel

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?