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

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

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

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