Using Solver in VBA in a loop

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
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
 
I found the secret.
Apparently loading the SOLVER sla has to be done for each workbook.
Once I did that, everything was fine.
Jim
 
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
 
Back
Top