AJ HER
2 posts
TimePosted 08/02/2016 14:52:11
AJ HER says

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.

Belite
16 posts
TimePosted 09/02/2016 10:56:55
Belite says

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

AJ HER
2 posts
TimePosted 09/02/2016 16:51:42
AJ HER says

re Yet Another Raw Mix Design program

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

Reply