Minimize Excel When Running a Macro

[Paul Vovk]

Seems like this is a simple thing, but I can't seem to get
it. I want Excel to run minimized when the macro (VBA
code) runs. A separate script starts Excel and this macro.
The macro runs and then shuts down Excel. This is done
once per day. I need the macro to first minimize Excel so
it doesn't show up on the screen while the macro is
running as it takes ~10 minutes to run.

 

[Bob Phillips]

This is how to minimize the app

application.windowstate=xlminimized

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)