Automatic use of Solver in an Excel model
 

Hello everybody,

I'm building a model for my study in Excel with the use of solver. M
question about the use of solver is:

Can solver automatic solve if I change something in the model? So tha
I don't have to go threw the whole proces of solver manually eac
time.

This would save me a lot of time, because I have to change a lot o
things in the model for my results.

Thanks Jaspe

--
Jaspe
-----------------------------------------------------------------------
Jasper's Profile: http://www.excelforum.com/member.php...fo&userid=3429
View this thread: http://www.excelforum.com/showthread.php?threadid=54060

Automatic use of Solver in an Excel model
 

Here are my two favorite programming tools (the secret's out!):

1. Use the Macro Recorder while you manually carry out a Solver solution.
2. Google for VBA Solver

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

"Jasper" wrote in
message ...

Hello everybody,

I'm building a model for my study in Excel with the use of solver. My
question about the use of solver is:

Can solver automatic solve if I change something in the model? So that
I don't have to go threw the whole proces of solver manually each
time.

This would save me a lot of time, because I have to change a lot of
things in the model for my results.

Thanks Jasper


--
Jasper
------------------------------------------------------------------------
Jasper's Profile:
http://www.excelforum.com/member.php...o&userid=34292
View this thread: http://www.excelforum.com/showthread...hreadid=540605