Solved: set reference to addin using code

[abhiker]

can an addin be referenced using code? i want to be able to do this for the user when i install the addin. thanks.

[RichardSchollar]

Hi

Something like this:

 Private Sub Workbook_Open()
   AddIns("Solver Add-In").Installed = True
   On Error Resume Next
   Application.VBE.ActiveVBProject.References.AddFromFile (Application.LibraryPath & "\solver\solver.xla")
End Sub

Richard