Investigate Solver SDK:
http://www.solver.com/developer.htm
Perhaps it has what you need.
--
Gary''s Student - gsnu2007
"jerome drean" wrote:
as some may know you can use the excel solver from vba - i wonder if it is
possible to use the solver from vba without interacting with the worksheet
object / range - ie i dont see why we cannot access the functionalities of
the solver by giving him an optimisation problem using a function defined in
vba
this comment could be applicable to many other cases such as graphs for
example
i hope i make sense to some of you