I studied VBA and succeeded, and I wrote some basic code around Excel Solver. No matter how reliable Excel Solver is, it is simply not fast enough for my optimization task (one iteration takes 20 minutes).
I looked around and talked with more experienced programmers, and the consensus is that VBA is simply not fast and that C ++, C # and especially CUDA are much faster.
Looking at the VBA modules in Excel, the Solver module is locked with a password. I searched for this password and where it can be acquired in a few weeks to no avail.
Questions: Can I get this password? If so, how? Can I buy it from Microsoft? How many?
Purpose. To force Solver VBA to potentially convert it to C # or C ++ to speed up the optimization process.
PS I looked at the Microsoft Solver Foundation, but it did not help.
Thank.
source
share