Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically add a Reference to an Add-In in VBA (Excel 2000?)
Is it possible, in VBA, to ADD a reference to an Addin dynamically -
WITHOUT using the Tools/Reference dialog box? In other words: I have an Addin (.xla) that contains functions/methods. I wish to use these functions/methods in the VBA of a WorkBook. I do not know where the .xla is located - except that it's in the same folder as the Workbook itself. And Finally, since many people will be using the Workbook, I do not want to ask them to 'manually' add a 'reference' to the XLA. This has to be done automatically... So, is it possible to Dynamically add a reference to my Add-In, using VBA in Excel 2000 (without requiring any other add-ins if possible?) THANKS !! Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted | Excel Worksheet Functions | |||
How to reference cells dynamically | Excel Discussion (Misc queries) | |||
How to dynamically add a reference to personal.xls ? | Excel Programming | |||
Excel 2000 Dynamically Set Print Area | Excel Programming | |||
Changing Reference Dynamically | Excel Programming |