Solver fails at first call

[perco754]

Hi,

I'm using Excel Solver to do some simple optimization. Each time I do a call through macros the Solver fails to fins a feasible solution (solver returning integer = 5). Then when I do another call with the same input, it works. It keeps on working fine as long as the Excel application is running.

Seems like something is happening during the initialization process.

BR,
perco

 

[Andrew Poulsom]

This may help you:

http://peltiertech.com/Excel/SolverVBA.html

 

[perco754]

Thanks,, However, I'm already using the suggested code for handling Solver related problems from that very same site. It's this code that wants you to call the Autpen function prior to doing your first solver calculation. Please see your own answer on my previous Solver-thread! I'm really lost regarding this issue. And I'm even more lost since I know that everything's been working fine before. This code has been running without any reported problems since 2008. BR, perco

This may help you:

http://peltiertech.com/Excel/SolverVBA.html