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).
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.
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.
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.
P.S. I've looked at Microsoft Solver Foundation but it wasn't helpful.
Thank you.
For free use by everyone, problem size limits in this Solver add-in are the same as in the Excel Solver (200 decision variables and 100 constraints in addition to bounds on the variables).
Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet.
You can use this password to unlock the SOLVER.XLAM project;
Wildebeest!!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With