Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Solver add-in question

  Asked By: Ricky    Date: Dec 25    Category: MS Office    Views: 614
  

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?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Solver add-in question Or get search suggestion and latest updates.




Tagged: