View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Minimize Excel When Running a Macro

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


-----Original 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.
.