| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Solver Macro
I want to create a macro that automatically runs solver when a button is
pushed. I went ahead and recorded it, however every time I run it a dialogue box pops up asking me if I want to keep the solver solution. I always want to keep the solution and I don't want to have to hit ok every time. My macro will eventually run other functions after it solves, so I want it to be smooth and not stopped by this dialogue box. Is there anyway to default this box to always accept the solution? Any input would be greatly appreciated. Thanks Adam Bush |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Solver Macro
Is there anyway to default this box to always accept the solution?
Any input would be greatly appreciated. Hi. Add the option True. SolverSolve True HTH Dana DeLouis wrote: I want to create a macro that automatically runs solver when a button is pushed. I went ahead and recorded it, however every time I run it a dialogue box pops up asking me if I want to keep the solver solution. I always want to keep the solution and I don't want to have to hit ok every time. My macro will eventually run other functions after it solves, so I want it to be smooth and not stopped by this dialogue box. Is there anyway to default this box to always accept the solution? Any input would be greatly appreciated. Thanks Adam Bush |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Solver Macro
Thank you very much. My problem was I recorded the macro and it didn't save
this setting. Adam Bush "Dana DeLouis" wrote: Is there anyway to default this box to always accept the solution? Any input would be greatly appreciated. Hi. Add the option True. SolverSolve True HTH Dana DeLouis wrote: I want to create a macro that automatically runs solver when a button is pushed. I went ahead and recorded it, however every time I run it a dialogue box pops up asking me if I want to keep the solver solution. I always want to keep the solution and I don't want to have to hit ok every time. My macro will eventually run other functions after it solves, so I want it to be smooth and not stopped by this dialogue box. Is there anyway to default this box to always accept the solution? Any input would be greatly appreciated. Thanks Adam Bush |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing a macro that updates solver solutions? | Excel Worksheet Functions | |||
| Is it possible to run Solver using a macro? | Excel Worksheet Functions | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| 2 questions: Using solver in Macro AND converting to Word document to print A3 | Excel Discussion (Misc queries) | |||
| How do I respond to a Solver Results Dialog Box from a macro? | Excel Discussion (Misc queries) | |||
Linear Mode
