This link maybe usufel for you...
http://peltiertech.com/Excel/SolverVBA.html