chaz_mac
Board Regular
- Joined
- Mar 9, 2007
- Messages
- 76
I want to run Solver (Excel 2007) as part of a macro, but not have the dialog box pop up prompting me to keep the result, etc.
code is simple :
Application.Run "SolverOk", "$I$4", 3, "0", "$I$3"
Application.Run "SolverSolve"
a post from 2007 suggests adding
Application.DisplayAlerts = False
before the solver call. this does not work.
Any ideas?
thanks -
Chaz
code is simple :
Application.Run "SolverOk", "$I$4", 3, "0", "$I$3"
Application.Run "SolverSolve"
a post from 2007 suggests adding
Application.DisplayAlerts = False
before the solver call. this does not work.
Any ideas?
thanks -
Chaz