I want to write a little .exe file, I think, to send to other users
to do two easy things:
1) load Excel's Solver add-in, and
2) load the VBA reference to Solver "reference to Solver.xla" in the
VBA Project Explorer.
I would just send the users this .exe file, asking them to run it,
and it would click both of those options on for them.
Is this possible?
According to the VBA recorder, the VBA command for the Solver is
AddIns("Solver Add-in").Installed = True
but
1) I don't know the VBA command to turn on the VBA reference to
Solver.xla in a new VBA project, and
2) I don't know how to save the whole thing as an executable file.
Can anyone help?