Problem calling third-party application OpenSolver using VBA

I am trying to run OpenSolver using a VBA command, but something does not seem to be working.

As the OpenSolver website recommends I populate Solver (NOT OpenSolver) using VBA code. Next, OpenSolver “copies” the Solver inputs – i.e. the cell I am trying to maximize/minimize, edit cells, constraints, etc…

I use OpenSolver and not Solver because my model has more than 200 variables.

When I run OpenSolver through the ribbon menu everything works out correctly.

Instead of using the ribbon menu I just need a snipped of code to do that actual run command through VBA.

I follow the instruction in the link below but still nothing.

http://opensolver.org/opensolver-api...#RunOpenSolver

Any ideas?

I assume you set a reference to "OpenSolver" in Visual Basic -> Tools -> References -> OpenSolver?

Alf

Thanks for rep

As your thread now is marked "Solved" I assume that a missing reference was the problem.

Myself I've used "OpenSolver" on several occations were the Excel Solver was not powerfull enough but so far have not used it in combination with VBA. Would it be possible for you to post your code and upload the file as I'm interested to learn more about possible uses of "OpenSolver"

Alf