How do I use Open Solver in Excel using VBA

Question

I have a problem that has a lot of variables and the normal excel solver takes a lot of time to solve the problem. I am using the excel opensolver as it is faster and more efficient. I tried to record a macro but could not see any code related to opensolver. I need to access open solver using VBA just like we do for normal excel solver.

Thanks in advance!

Ru Hasha · Accepted Answer · 2016-04-07 18:38:32Z

4

This is how I got it working for a toy optimization problem I just created:

Add the Opensolver reference to your VB project

Call the solver as in this example code:

Sub Test_OpenSolver()
    OpenSolver.RunOpenSolver , False
    'Q: Why False as a Second parameter?
    'A: MinimiseUserInteraction If True, all dialogs and messages will be suppressed. Use this when automating a lot of solves so that there are no interruptions. Defaults to False
End Sub

answered Apr 7, 2016 at 18:38

Ru Hasha

9561 gold badge7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew · Accepted Answer · 2016-04-13 11:01:11Z

1

OpenSolver does not have any ability to record macros; it is not a feature our users have ever requested. However it does have a well documented VBA interface; see http://opensolver.org under Using OpenSolver.

answered Apr 13, 2016 at 11:01

Andrew

111 bronze badge

Collectives™ on Stack Overflow

How do I use Open Solver in Excel using VBA

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related