#1   Report Post  
Posted to microsoft.public.excel.misc
Ali Ali is offline
external usenet poster
 
Posts: 80
Default Solver

Any body knows how to run solver from a VBA macro?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Solver

Run Solver manually with the recorder turned on.

HOWEVER make sure that in VBA:

Tools References Solver is check first
--
Gary''s Student - gsnu200789


"Ali" wrote:

Any body knows how to run solver from a VBA macro?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Solver

Also, this may be helpful:

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

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


"Gary''s Student" wrote in message
...
Run Solver manually with the recorder turned on.

HOWEVER make sure that in VBA:

Tools References Solver is check first
--
Gary''s Student - gsnu200789


"Ali" wrote:

Any body knows how to run solver from a VBA macro?



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 Help brownti via OfficeKB.com Excel Worksheet Functions 9 July 2nd 07 05:08 PM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Solver Scott Excel Discussion (Misc queries) 1 September 29th 05 07:15 PM
Solver Janus Excel Discussion (Misc queries) 5 September 2nd 05 07:23 PM
Solver Jake Excel Discussion (Misc queries) 0 May 18th 05 10:20 PM


All times are GMT +1. The time now is 09:06 PM.

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

About Us

"It's about Microsoft Excel"