View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tjtjjtjt tjtjjtjt is offline
external usenet poster
 
Posts: 51
Default could not get solverget working

Please post something more detailed for an in depth response.

You can always look at www.solver.com for more information.

--
tj


" wrote:

I try to dump the solver parameters on a spread sheet. I find the
following problems.

SolverGet(4) returns an #Value! error. it is supposed to return an
reference to the changing cell.

SolverGet(7) returns a blank array. It is supposed to an array of
numbers, which indicate the signs of constraints.

Others seem to work well.
anybody know how to address this problem?





thanks,
De

PS: Solver sucks! It offers unfriendly and poorly documented program
interface.