Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro tool for solver
I am writing a macro tool for the solver function and i don't want the
solver results box to pop up in the worksheet, i just want to use the solver values, How do i do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro tool for solver
I am writing a macro tool for the solver function and i don't want the
solver results box to pop up in the worksheet, i just want to use the solver values, How do i do this? http://www.frontsys.com/mlvbaref.htm HTH, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro tool for solver
I'm not sure what it is you're trying to accomplish. I
have loaded solver set cell, constraints, etc. and solved for a result without any user dialog with solver. The resulting optimal solution was put into the designated cells of a worksheet. Is this what you are trying to do? Joe -----Original Message----- I am writing a macro tool for the solver function and i don't want the solver results box to pop up in the worksheet, i just want to use the solver values, How do i do this? http://www.frontsys.com/mlvbaref.htm HTH, Merjet . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro tool for solver
If I understand the question, one is trying to not have the result dialog
box pop up when Solver is finished. Results = SolverSolve(UserFinish:=True) Use "Results" to determine how solver did. I don't want the solver results box to pop up ... HTH. (Note that in Windows, this is backwards (in my opinion). It should be False, because one does not want the User to interface with Solver when done. Don't know why they changed this from the Apple version.) -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = wrote in message ... I'm not sure what it is you're trying to accomplish. I have loaded solver set cell, constraints, etc. and solved for a result without any user dialog with solver. The resulting optimal solution was put into the designated cells of a worksheet. Is this what you are trying to do? Joe -----Original Message----- I am writing a macro tool for the solver function and i don't want the solver results box to pop up in the worksheet, i just want to use the solver values, How do i do this? http://www.frontsys.com/mlvbaref.htm HTH, Merjet . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL solver macro | Excel Worksheet Functions | |||
excel solver tool | Excel Discussion (Misc queries) | |||
Is it possible to run Solver using a macro? | Excel Worksheet Functions | |||
help with solver or macro | Excel Programming | |||
Solver Macro | Excel Programming |