Menu

Reference to solver problem

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

Bill Martin[_2_] Bill Martin[_2_] is offline

Bill Martin[_2_] is offline

external usenet poster

Posts: 105

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Interesting Solver problem (Solver encounters an error)	MrShorty	Excel Discussion (Misc queries)	3	December 22nd 05 10:52 PM
VBA Excel Solver ValueOf: Reference Problem	Karl	Excel Programming	3	July 9th 05 05:49 PM
Solver automatically in the VBA Reference	No Name	Excel Programming	1	June 18th 04 12:25 AM
Solver reference problem	Martien Janssen[_2_]	Excel Programming	2	April 9th 04 03:06 PM
VBA code to add a reference to solver	Tbeek[_3_]	Excel Programming	5	April 7th 04 04:46 PM

All times are GMT +1. The time now is 03:26 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement