VBA code to disable Make Unconstrained Variables Non-Negative in solver?

[jasonleewkd]

Hi all, is there no VBA code to do the above?


MSDN help says to use SolverGet but it does not seem to work.


Similarly, when I record a macro and run solver, the part where I untick the checkbox does not seem to appear?


Anyone got any tips on this?


The excel file is at the link and the module is titled "MaxReturnNoShort" a.k.a Max Return No Short(ing)

https://docs.google.com/file/d/0BzQyFnW9qIEXZTd4dGRJQ1UtU28/edit?usp=sharing


Cheers

 

[Luke M]

Looking at this block of code, my guess would be that it's the last option you want to toggle True/False.

[pre]

SolverOptions MaxTime:=100, Iterations:=100, Precision:=0.000001, AssumeLinear _
:=False, StepThru:=False, Estimates:=1, Derivatives:=1, SearchOption:=1, _
IntTolerance:=5, Scaling:=False, Convergence:=0.0001, AssumeNonNeg:=True

[/pre]