Solver with Macro - need guidance for a small project

[prashantha]

I tried to do small project on solver.

Now I have faced a situation where I need your guidance to go forward.

I attached herewith a Excelsheet with a solver modle & I wish to run it with a macro. I tried sevaral ways but stil I didn't find a solution. I need to load objecctive, variable cells & constraints to a solver modle & slove it just clicking the "solve button".



pls help me to code this in VB or to write a macro.



Thank you.