solver in macro

kristofvdz · Mar 28th, 2002, 03:44 PM

I want to make a macro that uses the excel solver, is this possible? and if its possible how do you do it, i always keep getting errors.

[ This Message was edited by: kristofvdz on 2002-03-28 14:55 ]

Joe Was · Mar 28th, 2002, 04:15 PM

You do the equivalent of Tools-Solver with the VBA clip:

SolverOK setCell:=Range("AA6"),maxMinVal:=1, byChange:=Range("B8:C11")

Where the trick is "SolverOK" which is the same as Tools-Solver. Note: you need to set the options and you will need additional Solver methods and properties.

The Solver.xla must be installed for these codes to work. JSW

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 03:44 PM	#1
kristofvdz New Member Join Date: Mar 2002 Posts: 1	I want to make a macro that uses the excel solver, is this possible? and if its possible how do you do it, i always keep getting errors. [ This Message was edited by: kristofvdz on 2002-03-28 14:55 ]

Mar 28th, 2002, 04:15 PM	#2
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	You do the equivalent of Tools-Solver with the VBA clip: SolverOK setCell:=Range("AA6"),maxMinVal:=1, byChange:=Range("B8:C11") Where the trick is "SolverOK" which is the same as Tools-Solver. Note: you need to set the options and you will need additional Solver methods and properties. The Solver.xla must be installed for these codes to work. JSW