Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting Solver with VBA
I just need to start Solver with code, i.e. the equivalent to clicking Tools,
Solver (which remembers all parameters from the last time Solver was used on the active sheet)? Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting Solver with VBA
Turn on the macro recorder (Tools menu), use Solver manually, turn off
the recorder. The code will be in the VB Editor. Check Solver using the menu Tools | References in the VB Editor. Hth, Merjet |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting Solver with VBA
That works if I actually do some solving with Solver but it doesn't record
code just to display the dialog box - which is all I want it to do. "merjet" wrote: Turn on the macro recorder (Tools menu), use Solver manually, turn off the recorder. The code will be in the VB Editor. Check Solver using the menu Tools | References in the VB Editor. Hth, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting Solver with VBA
Hi.
Sub Solver_Show() SOLVER.Main End Sub -- HTH :) Dana DeLouis Windows XP & Office 2007 "Smallweed" wrote in message ... That works if I actually do some solving with Solver but it doesn't record code just to display the dialog box - which is all I want it to do. "merjet" wrote: Turn on the macro recorder (Tools menu), use Solver manually, turn off the recorder. The code will be in the VB Editor. Check Solver using the menu Tools | References in the VB Editor. Hth, Merjet |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
starting Solver with VBA
Thanks very much Dana - just what I needed.
(in case anyone else nees this, you have to tick Solver in Tools, References in the VB Editor first) "Dana DeLouis" wrote: Hi. Sub Solver_Show() SOLVER.Main End Sub -- HTH :) Dana DeLouis Windows XP & Office 2007 "Smallweed" wrote in message ... That works if I actually do some solving with Solver but it doesn't record code just to display the dialog box - which is all I want it to do. "merjet" wrote: Turn on the macro recorder (Tools menu), use Solver manually, turn off the recorder. The code will be in the VB Editor. Check Solver using the menu Tools | References in the VB Editor. Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to replace Excel solver with some free solver codes in Excel V | Excel Programming | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Starting add-in using vba | Excel Programming | |||
Resetting Solver Manually to Fix Solver Bug | Excel Programming | |||
Starting a userform upon starting the file | Excel Programming |