View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default solver add in / excel solver / vba

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