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.

 

[Tod]

You can have your script open Excel in memory and not have
it appear on the screen, like this:

'Create an instance of Excel
Set xl = CreateObject("Excel.Application")
'Open the workbook
Set CurrentBook = _
xl.Workbooks.Open"C:\MyPath\MyWorkbookName.xls")
'Run a procedure called Main in Module1
xl.Run "Main"
'Save and Close the workbook
CurrentBook.Save
CurrentBook.Close
'Close the instance of Excel
xl.Quit

Excel, nor the workbook, will never appear on the screen.

tod

set CurrentBook = nothing
set xl = nothing