LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #27   Report Post  
Posted to microsoft.public.excel.programming
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
 
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
Solver model loading problem marineCORVETTEran Excel Discussion (Misc queries) 0 July 17th 08 11:31 PM
Referencing and loading Solver programatically - how? CodeMonkey Excel Programming 11 May 4th 06 05:27 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Add-in loading problem richardreye Excel Programming 0 September 6th 04 03:31 AM
File Loading Problem Jason Hancock Excel Programming 1 June 20th 04 08:53 PM


All times are GMT +1. The time now is 03:02 PM.

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"