Home |
Search |
Today's Posts |
#27
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Solver model loading problem | Excel Discussion (Misc queries) | |||
Referencing and loading Solver programatically - how? | Excel Programming | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Add-in loading problem | Excel Programming | |||
File Loading Problem | Excel Programming |