Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Solver
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Solver
Resolved · Low Priority · Version 2003
Reply Wed 19 Nov 2008, 16:33Delegate Morgan said...
Morgan has attended:
No courses
Solver
Hi
Does anyone know any code for using the solver add-in? I currently have some based on a macro I recorded, but it runs very slowly.
Thanks!
For upcoming training course dates see: Pricing & availability
RE: Solver
Hi Morgan
Thank you for your question
First you need to switch on the solver reference. Click on tools, references and select solver.
There are a number of functions available
SolverOptions allows you to specify the basic parameters of the problem, e.g whether you are maximising or minimising
SolverAdd adds a constraint
SolverSolve seeks a solution
SolverChange changes an existing constraint
I suggest typing solver into the VB help function. There are detailed descriptions of the function arguments together with examples of their use
Regards
Stephen
Reply Mon 2 Mar 2009, 08:31Delegate Morgan said...
RE: Solver
Thanks very much for the reply
|