Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
Minimize Excel When Running a Macro | Excel Programming | |||
Running a excel macro from VB6 | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
Running Excel Macro from VB6 | Excel Programming |