View Single Post
  #30   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Problem loading Solver

On Tuesday, December 17, 2019 at 12:52:13 PM UTC-6, Peter T wrote:
"programmernovice" wrote in message
Peter T

Thanks Peter. In case it's helpful to you:

SolverSolve True

works. Regards

Indeed that's what the documentation says, but don't be surprised if
the
dialog appears again!

Peter T

.. and looking back at your post with your code you already had exactly
that...?

PT

Well, for now it works. My code had just

SolverSolve

Addition of "True" appears to have helped. Hopefully it will remain so.
Thanks, regards


Fair enough and my memory may well be wrong on this.

FWIW in what you said yesterday was your code (when you said it was giving a
compile error) SolverSolve included True:

solverSolve (True)

Peter T


I wonder if adding True without parentheses helped? At any rate it appears
to work for now. Thanks again for your interest.


Normally, the parenthesis are not needed when the method is not on the right
hand side of '=', OR when the enclosed does not include an operator.

SolverSolve True 'correct syntax
SolverSolve (True) 'incorrect syntax

With operator involved:
ret = SolverSolve(True) 'correct syntax if SolverSolve returns a value
bSuccess = (Err = 0) 'correct syntax using an operator
returns True if no error, otherwise returns False

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion