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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.