SolverOk with dynamically changing objective function

[Apudo]

Dear All,

I am working on a macro that is using the Excel add-in solver. The problem to be solved is a problem of dynamic programing. More specifically, there is a series of nested optimization problems, the solution of which is used as a parameter in the next optimization problem. Since the objective function depends on the solution of each of the previos problems, it is changing dynamically. Since, this opbjective function is going to be an input of the SolverOk function (which in fact is a cell in an MS Excel worksheet)there must be a way to generate dynamically formulat to be written next in an MS Excel cell.

Does anybody have any experience with using Solver from the VBA code level.

Thanks in advance for any help,

l.onion

 

[stephanowitsch]

Hi i.onion, I would have the same problem and am just interested if you already found a solution?
Cheers steve