ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reference to solver problem (https://www.excelbanter.com/excel-programming/350489-reference-solver-problem.html)

[email protected]

Reference to solver problem
 
I have developed a spreaadsheet that uses VBA to call solver. I plan to
give the workbook to people, some of whom do not even know solver
exists and so have not installed it. Does anyone know of code that
checks to see if solver is installed and if not installs it and fixes
the possibly broken reference to it in VBA?

Thanks for any light people may be able to shed on the subject

Tim Steer


Bill Martin[_2_]

Reference to solver problem
 
wrote:
I have developed a spreaadsheet that uses VBA to call solver. I plan to
give the workbook to people, some of whom do not even know solver
exists and so have not installed it. Does anyone know of code that
checks to see if solver is installed and if not installs it and fixes
the possibly broken reference to it in VBA?

Thanks for any light people may be able to shed on the subject

Tim Steer

---------------

It's been a long time since I installed Solver, but as I recall it involved
putting the original distribution disk into the computer. I don't see how
software can do that on its own.

You suspect you can check to see if it's installed by using an ON ERROR
statement and then trying to invoke solver. And if you find it's not installed
you can provide a text prompt to the user telling them how to install Solver. I
don't see how you can install it from software though without violating
somebody's copyright.

Maybe someone here will have a better answer for you.

Bill

Bill Martin[_2_]

Reference to solver problem
 
wrote:
I have developed a spreaadsheet that uses VBA to call solver. I plan to
give the workbook to people, some of whom do not even know solver
exists and so have not installed it. Does anyone know of code that
checks to see if solver is installed and if not installs it and fixes
the possibly broken reference to it in VBA?

Thanks for any light people may be able to shed on the subject

Tim Steer

---------------

It's been a long time since I installed Solver, but as I recall it involved
putting the original distribution disk in the computer. I don't see how
software can do that on its own.

I suspect you can check to see if it's installed by using an ON ERROR RESUME
NEXT statement and then trying to invoke solver. And if you find it's not
installed you can provide a text prompt to the user telling them how to install
Solver. I don't see how you can install it from your software though without
violating somebody's copyright.

Maybe someone here will have a better answer for you.

Bill


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com