View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Solver VBA - Defining Solver Options

I have a bunch of links at the bottom of this page which might help:

http://peltiertech.com/Excel/SolverVBA.html

Did you try recording a macro while you adjusted these parameters?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Kyle" wrote in message
...
I'm using the basic version of solver that comes with excel. I've been
defining the constraints, variables etc using VBA macros as shown in
article
843304. I now need to define the max time, number of iterations,
precision
etc - basically the options that you can define from the actual Solver
Parameters window. Does anyone know how you can define these options
within
VBA code? It isn't discussed in the aforementioned article. Is there
perhaps another article that discusses this material?

Thanks in advance!