Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Solversolve Control Macro
Solver manipulates input variables to make a target
function in a cell achieve a maximum, minumum or specified value. However, if the target value is to be generated by a 500 line VB Visual Basic program, how does one get the Solver to drive the VB program? Is this possible? I've tried ShowRef:="Validator II", which is the start of the VB program, but the system just twitches a few times and exits. Setting PassThru:= does not change anything. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How does Solversolve Control Macro
http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver perhaps that will shed some light. -- Regards, Tom Ogilvy "Dacvid Cardner" wrote in message ... Solver manipulates input variables to make a target function in a cell achieve a maximum, minumum or specified value. However, if the target value is to be generated by a 500 line VB Visual Basic program, how does one get the Solver to drive the VB program? Is this possible? I've tried ShowRef:="Validator II", which is the start of the VB program, but the system just twitches a few times and exits. Setting PassThru:= does not change anything. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
control end in a macro | Excel Worksheet Functions | |||
Control button / macro | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro control | Excel Programming | |||
How to call SolverSolve portably for Excel XP and Excel 2000 | Excel Programming |