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