Installing and Enabling Solver on Workbook Open

[shoulddt]

Hello all,
I have a workbook that I would like to distribute to others. The workbook uses the Solver add-in. To ensure all users have Solver installed and enabled on their versions of Excel I wanted to create a WorkbookOpen event that checks for it, and if it isn't installed installs it then enables the reference.

I have the following code. There is no way of telling if the installation portion works or not because I already have it on my machine. However it does not enable the Solver add-in in the References list. Could someone point me in the right direction on how to accomplish the installation and activation of Solver?

Please Login or Register  to view this content.

[Raphaelp]

1.

There is no way of telling if the installation portion works or not because I already have it on my machine.

You can simply remove solver from your Excel to test the macro.

2. You can simply embed a document with the easy-peasy instructions on how to enable Solver. And if someone can't figure that out, then they also won't know to enable macros to get your macro to work.

[Alf]

Depending on the excel version the solver file is named "Solver.xla" up to Excel 2003.

For Excel 2007 to 2010 the name is "Solver.xlam" and probably the same for Excel 2016.

But I'm not sure you can set a reference to solver using VB.

Alf