Login
Technical Cement Forum / re Yet Another Raw Mix Design program
The forum in now closed, please join us on the International Cement Review Linkedin Group

AJ HER
AJ HER

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

Belite
Belite

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 ...

AJ HER
AJ HER

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

maajdl
maajdl

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.