amas008 / SolverStudio-stub

2 stars 4 forks source link

Make "VBA Example.xlsm" language-independent #5

Open amarvin opened 6 years ago

amarvin commented 6 years ago

VBA module "Module 1" of this example Excel file has a script for running the SolverStudio "Solve model" command from VBA, but it does not work in non-English installations of Excel. Can this be updated to be language-independent? Specifically, requesting the "Data" ribbon by name often fails in other languages, because that ribbon has a different local name.

amarvin commented 6 years ago

This script also should be made compatible with 64-bit Excel. Specifically, the VBA declarations should include PtrSafe (refer to this stackoverflow answer).