PDA

View Full Version : Solved: set reference to addin using code



abhiker
02-06-2008, 07:13 PM
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
02-07-2008, 01:14 AM
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