vba 从宏运行 Excel 求解器

run Excel Solver from macro

提问by user990330

I want to run Excels Solver from a Macro. I already have all the algorithm parameters manually entered into the Solver window. By just calling

我想从宏运行 Excels Solver。我已经将所有算法参数手动输入到求解器窗口中。只需调用

SolverSolve

I get a compile error.

我收到编译错误。

Any idea how to do this?

知道如何做到这一点吗？

回答by Olle Sj?gren

You must set a reference to the Solver addin in Tools/References:

您必须在 Tools/References 中设置对 Solver 插件的引用：

1. Select References from the Tools menu in the Excel VBA editor window.
2. Check the "Solver" checkbox.
3. Click OK.

1. 从 Excel VBA 编辑器窗口的工具菜单中选择引用。
2. 选中“求解器”复选框。
3. 单击确定。