Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Solver model loading problem marineCORVETTEran Excel Discussion (Misc queries) 0 July 17th 08 11:31 PM
linear model with solver vert Excel Discussion (Misc queries) 1 April 4th 06 04:34 PM
Solver. When a model is liner and when it's not? PV Excel Discussion (Misc queries) 1 February 15th 06 04:16 PM
how do i model discounts in excel solver Samir Syed Excel Worksheet Functions 0 December 23rd 05 05:23 PM
Solver and VBA in the same model mcglynn Excel Programming 0 January 7th 04 10:06 AM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"