Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default could not get solverget working

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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate working days but change working week SamB Excel Discussion (Misc queries) 1 September 1st 08 09:17 PM
Making weekend days working days - the system cuts the working tim Fluffy Excel Discussion (Misc queries) 1 May 30th 08 10:02 PM
macro was working, now it's not working RichardO[_11_] Excel Programming 2 June 9th 04 06:27 AM
Macro working in Excel 2003; not working in Excel 2000 Leslie Barberie Excel Programming 5 May 20th 04 07:51 PM
Adding sales from a non working day to the previous working day Alex Excel Programming 1 September 19th 03 08:48 AM


All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"