Supressing Excel Solver Windows 1

[jfeegler]

I figured out how to automate Solver using excel vba, does anyone know how I can suppress Solver's pop-up windows? Thanks for your help.

 

[longhair]

jfeegler,

have you tried setting:
Application.DisplayAlerts = false
before your solver code and then setting them back to true after?

regards,
longhair

 

[SkipVought]

Hi,

Try

with application
  .displayalerts=false
  .screenupdating=false
end with
' you code here
...
with application
  .displayalerts=true
  .screenupdating=true
end with

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[RobBroekhuis]

It's easier than all that. Just use

solversolve true

to suppress the results window popup.


Rob

 

[SkipVought]

Rob, Rob, Rob!

Soooooooooo simple!

You da MAN! ==> STAR

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[MeGustaXL]

Hi Guys,

Sorry to be a Buttinski, but I haven't figured out how to automate solver!

Would anyone please give me a quick pointer as to how to automate this process:

Minimise $A$12 by changing $B$1, $B$2 and $B$3, making sure that $B$1 is >0 and $B$2 >= $A$20

Many thanks in advance,



Chris

Varium et mutabile semper Excel