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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically add a Reference to an Add-In in VBA (Excel 2000?)
Dim a As AddIn
Set a = Application.AddIns.Add("someaddin.xla", True) a.Installed = True Tools/references in VBA adds references to dll or other components not a addin Addin can be added from tools/addins from excel's main window itself. "Richard" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically add a Reference to an Add-In in VBA (Excel 2000?)
try:
Sub AddMeAsReference() If ActiveWorkbook Is ThisWorkbook Then Beep If ActiveWorkbook.VBProject.Name = ThisWorkbook.VBProject.Name Then Beep Else ActiveWorkbook.VBProject.References.AddFromFile ThisWorkbook.FullName End If End Sub BUT (and it's a BIG but) the user's security settings can allow and prevent "Access to Visual Basic Project" if that access is OFF than any attempt to read or alter vbproject properties will fail. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Richard wrote : 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 |
Reply |
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 |