Integrating Solver add-in, using VBA code

**salilcheeran** · 08-16-2009, 12:58 PM

Hi,

I wanted to integrate the built-in solver add-in to an excel sheet and execute it using VBA code to do optimization.

I am able to integrate the solver add-in using the following code.

Please Login or Register  to view this content.

Please let me know how to set the values for the cell values dynamically?

Regards
Salil Cheeran

**shg** · 08-16-2009, 05:15 PM

You could start by recording a macro that uses Solver to do whatever you're doing.

**Jorobli** · 03-21-2011, 01:23 PM

On 16 Aug 2009 salilcheeran wrote this code example (which is fantastic):
If AddIns("Solver Add-in").Installed = False Then
AddIns("Solver Add-in").Installed = True
End If

My problem is - my users will not know how to activate the Solver add in (if they know what an add in is - for them the code must work (the code being an automated through VBA Solver solution finder)).
My question is, is there similar code to the above for the second step to using an add in? The manual steps are: VBE / Tools menu / References followed by tick against Solver checkbox.
Thanks and appreciated
(Excel 2007)