rutherfordcpa

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?

Thanks.

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?

Thanks.

See http://www.mrexcel.com/forum/excel-questions/555618-excel-visual-basic-applications-enable-solver-visual-basic-applications-reference.html

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.