re Yet Another Raw Mix Design program

lalbatros this looks like an excellent file for raw mix design.  For some reason the macro is giving me an error telling me it cannot find the solversolve function.  Do you have a newer version, perhaps it is a problem with versions of Excel.  Thank you for the help.

Sub doSolve()
    On Error Resume Next
    Application.ScreenUpdating = False
    solverMessages
    Range("quantities").ClearContents
    model.setupModel
    model.solving = True
    solverStatusInt = SolverSolve(True)
    model.solving = False
    model.setupModel
    ActiveSheet.solveStatusBox = Now() & "   " & solverSolveStr(solverStatusInt)
    Application.Calculate
    Application.ScreenUpdating = True

Reply

Know the answer to this question? Join the community and register for a free guest account to post a reply.

re Yet Another Raw Mix Design program

When calling Solver from VBA, there must be a reference to solver.xlam (xla if version 2003 or older). I guess that reference is missing. Go to the VBA editor (ALT+F11), select Tools and References. The addin is somewhere in program files, Microsoft Office ...

Reply

re Yet Another Raw Mix Design program

Thanks Belite I was able to find it and it is working now.

Reply

re Yet Another Raw Mix Design program

There you can find Yet Another Raw Mix Design toy:
https://github.com/maajdl/YARMD

A 2 hours game that I first posted this here 10 years ago (Lalbatros):
https://www.cemnet.com/Forum/thread/149516?page=2

On GitHub the file is slightly modified because the first version was written in Excel 2003.
The reference to the Solver needed to be updated.

Reply