Link to home
Start Free TrialLog in
Avatar of rutherfordcpa
rutherfordcpaFlag for United States of America

asked on

Excel Solver

I have a spreadsheet that will be distributed to users that will be using x32 & x64 computers, XP and Windows 7, etc, and they would be using Excel 2003, 2007 or 2010.

In this spreadsheet, we use the Solver.

I need VBA code that when the workbook is first opened, it will first check and see if the Solver Ad-in is installed, and if not, it is installed.  I then need the "Solver" Reference in VBA to be checked if it is not already.

Can anyone help?

Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial