Thread
:
Reference to solver problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bill Martin[_2_]
external usenet poster
Posts: 105
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
Reply With Quote
Bill Martin[_2_]
View Public Profile
Find all posts by Bill Martin[_2_]