vba Excel 求解器密码：它是什么以及在哪里可以获得/购买？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/42345254/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel Solver Password: what is it and where can it be acquired/bought?
提问by Gian
I've been exploring VBA and excel and I've been writing a few basic codes around the Excel Solver. However robust the Excel Solver may appear, it's just not fast enough for my optimization problem (one iteration takes 20 minutes).
我一直在探索 VBA 和 excel，并且我一直在围绕 Excel Solver 编写一些基本代码。无论 Excel 求解器看起来多么强大，它都不够快，无法解决我的优化问题（一次迭代需要 20 分钟）。
I've been looking around and speaking with more experienced programmers, and the consensus is that VBA is simply not fast and that C++, C#, and especially CUDA languages are much faster.
我一直在环顾四周并与更有经验的程序员交谈，一致认为 VBA 根本不快，而 C++、C#，尤其是 CUDA 语言要快得多。
Looking at the VBA modules in Excel, the Solver module is locked by a password. I've been searching for that password and where it can be acquired for weeks to no avail.
查看 Excel 中的 VBA 模块，求解器模块被密码锁定。数周以来，我一直在寻找那个密码以及在哪里可以获得它，但无济于事。
Questions: Can this password be acquired? If so, how? Can it be bought from Microsoft? How much?
问题：这个密码可以获取吗？如果是这样，如何？可以从微软购买吗？多少？
Objective: To get the Solver VBA to be able to potentially convert it to C# or C++ to make the optimization process faster.
目标：使求解器 VBA 能够潜在地将其转换为 C# 或 C++，以加快优化过程。
P.S. I've looked at Microsoft Solver Foundation but it wasn't helpful.
PS我看过Microsoft Solver Foundation，但没有帮助。
Thank you.
谢谢你。
回答by Old Nick
You can use this password to unlock the SOLVER.XLAM project;
您可以使用此密码解锁 SOLVER.XLAM 项目；
Wildebeest!!
角马！！
回答by Charles Williams
The Solver solution module is not written in VBA: its already in C++. It is proprietary software developed by FrontLine Systems, who also market more capable solvers for a premium price. see
Solver 解决方案模块不是用 VBA 编写的：它已经用 C++ 编写了。它是由 FrontLine Systems 开发的专有软件，他们还以高价销售功能更强大的求解器。看
http://www.solver.com/
回答by Larry B.
Have you tried turning off Auto Calculate? If not it's under: Options > Formulas.
您是否尝试过关闭自动计算？如果不是，则位于：选项> 公式。
I have a file with 15 worksheets and if I updated 1 cell it would recalc all sheets :( I turned off auto calc and now use the ShiftKey+F9 to recalc the sheet I'm on. Much faster now.
我有一个包含 15 个工作表的文件，如果我更新了 1 个单元格，它将重新计算所有工作表 :( 我关闭了自动计算，现在使用 ShiftKey+F9 重新计算我所在的工作表。现在快得多了。
