Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-ins in Microsoft excel
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 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I covert Microsoft Word file into Microsoft Excel one? | Excel Discussion (Misc queries) | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) |