Minimize Excel When Running a Macro
 

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.

Minimize Excel When Running a Macro
 

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)

"Paul Vovk" wrote in message
...
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.