VBA code for Excel Solver

[artz]

Hi,

I was sure that somebody posted VBA code in this Forum that functioned equivalently to the built-in Excel Solver in Excel. Can somebody point me to that thread or repost that VBA code?

Thanks,

Art

 

[Worf]

Hi Art

I’m not sure I understood what you want to do:

1. Use VBA to call Solver within Excel.

https://www.mrexcel.com/forum/excel-questions/998509-solver-dynamic-named-ranges.html

2. Get code to solve a problem outside Excel.

Please clarify.

 

[artz]

Hi Worf,

I've tried Excel Add-in (from Excel) and Open Solver where most, but not all of the Solver code is available. The MS Solver is a 'black box'; I have no visibility into what's under the hood. As I enter more datasets into the mix to optimize parameters, both versions fail with the OpenSolver failing sooner, i.e., with fewer datasets in the optimization mix.

So what I would want is either the complete VBA code for the built-in Excel solver or the complete VBA code for a superior iterative solver.

Thanks,

Art

 

[Worf]

Hi Art

o Why exactly do you need the source code?
o Solver is a commercial product and the Excel add in is only a subset of it. You can have a two-week free trial at www.solver.com to see how it performs with your problem.
o If you are a company user, the yearly fee can be afforded. I never heard of a very powerful, complete and free solver.