Compiling VBA with Solver?

[Pthieber]

I would like to distribute an Excel simulation program that uses Solver. Is it possible to compile the VBA code so that the users don't need to have SOLVER.XLM or SOLVER.XLAM on their machines?
Thank you!
Peter

[Leith Ross]

Hello Peter,

Welcome to the Forum!

Solver is a program that is licensed by Frontline Systems. It is not a Microsoft product. That's why it is an Add-In. You could purchase a license from Frontline Systems to due development work, but it isn't cheap. If you plan to sell your program then the license cost may not be a factor. For more information click on the link below...

Solver Information and Pricing

[Pthieber]

Thank you Leith. My little simulation is not for any commercial use. It will only be distributed to a few users within my group, all of whom have valid Microsoft Office licences for their PCs. Do I understand correctly that the Solver version sold with Excel can't be compiled with the VBA code?
Thanks again,
Peter

[Leith Ross]

Hello Peter,

Correct, the code can not be compiled into the code. You could have the code load the Solver add-in module automatically.

[Pthieber]

Thank you Leith, I'll try to do that.
Regards, Peter