Open Solver Dialog in Excel via VBA

[Rudi]

Hi,

In Excel 2010, how does one write VBA script to activate the solver dialog for the current workbook? This action does not record.

TX

[HansV]

Make sure that you set a reference to Solver in Tools | References... in the Visual Basic Editor:

x160.png

You can then use the Solver in VBA.
Reference: Using the Solver VBA Functions.
The individual articles contain examples.

[HansV]

Oops, sorry, I see that I didn't read your question carefully enough. You want to open the Solver dialog using code, but I have no idea how to do that.

[Rudi]

Thanks for the replies. I have not found anything else on the web that reveals how to access the dialog. Since it's an addin, I don't think its possible. As you state...one can only access the Solver Functions. So code calculates the result internally without the need to show the dialog. One must obviously pass ranges/variables to the Solver functions directly.

TX.

[Becks]

For Excel 2007 and earlier, you could use
SOLVER.Solver1.Main

to call the dialog box


Kevin

[agibsonsw]

For Excel 2007 and earlier, you could use
SOLVER.Solver1.Main

to call the dialog box

Kevin

I'm guessing here but I assume if the dialog is shown and the user clicks Solve there might not be a way to trap this event? That is, it just uses the Solver feature and we are not able to achieve anything with our Solver code. So we can either create our own UserForm version of the Solver dialog, or read necessary details/arguments from a worksheet.

But I may be wrong..? Andy.