Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Solver in VBA in a loop
I have used Solver in VBA to solve optimization problems with good
results. HOWEVER, when I tried to use it in a Monte Carlo For-Next loop, the debugger highlights the 1st Solver function call. So here are my questions: 1) Is it possible to execute Solver in a "For-Next" or other loop? 2) Has anyone tried anything similar? Thanks, Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Solver in VBA in a loop
It's possible and I've done it.
What's your first Solver function call? In fact, I don't see any code here at all. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jim" wrote in message ... I have used Solver in VBA to solve optimization problems with good results. HOWEVER, when I tried to use it in a Monte Carlo For-Next loop, the debugger highlights the 1st Solver function call. So here are my questions: 1) Is it possible to execute Solver in a "For-Next" or other loop? 2) Has anyone tried anything similar? Thanks, Jim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Solver in VBA in a loop
I found the secret.
Apparently loading the SOLVER sla has to be done for each workbook. Once I did that, everything was fine. Jim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Solver in VBA in a loop
The xla only needs to be initialized once the first time you use it. But the
model has to be set up for each sheet, because Solver stores the parameters in the sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Jim" wrote in message ... I found the secret. Apparently loading the SOLVER sla has to be done for each workbook. Once I did that, everything was fine. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003 | Excel Programming | |||
Need advice on Solver loop | Excel Programming | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Automating Solver in loop | Excel Programming | |||
Error message when using the Solver in a VBA macro loop | Excel Programming |