Scheduled Tasks & Starting Excel in a Minimized Window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

Is there a command line start up switch that will start Excel in minimized
mode?

I found many switches, but not this one. The reason I would like to use it:
I am running several Excel programs from task scheduler. I would prefer
that the Excel screen would not pop up while I am working. I know I can hide
or minimize after Excel has open'd, but that takes a few seconds to happen.

I am not married to the "switch" idea - so if there is another way, I would
be happy hear about it. Thx.

Thank you for your assistance.
MSweetG222
 
Put this in a module, works for me, it maximised excel and the workbook

Sub auto_open

Application.WindowState = xlMaximized
Windows(1).WindowState = xlMaximized

end sub

(e-mail address removed)
 
Sorry, thought you said maximised

still use this code and it should minimise it
 
Thank you for the code. I will keep with my snippets.

I am looking to minimize excel BEFORE or AS excel starts.
For example, if you take the Excel.exe short cut, right mouse click, select
properties, you can change the "run" to minimized. Now when you click that
Icon, excel will minimize immediately. However, the same is not true on
short cuts to excel workbooks created by users.

The reason I need it is that I am running several Excel programs from task
scheduler. I would prefer that the Excel screen would not pop up while I am
working. I know I can hide or minimize after Excel has open'd, but that
takes a few seconds to happen.

Thx
MSweetG222
 
when I use this in the shortcut:

"C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e
"C:\Data\20020528sm.xls"

and set it to run minimized, it worked for me.
 
Thank you Tom!

My shortcut was missing the "C:\Program Files\Microsoft
Office\Office\EXCEL.EXE" /e portion of the request.
It works just fine now!

Thanks Again!
MSweetG222
 
It gives me great pleasure :thumb: to report that I know how to do this (start excel minimized on startup) and the good news is that it does not require any command line startup switches. I have been banging my head against the wall for a long time trying to find a way for windows task scheduler to run a excel worksheet minimized. The trick is to:

1) put an macro enambled excel file in
C:\Users\......\Microsoft\Excel\XLSTART

2) Create a shortcut on the desktop to:
C:\Program Files.....Office14\EXCEL.exe

3) right-click on the shortcut and select preferences and select run as minimized

4) click on the shortcut and the macro enabled excel file you put in the XLSTART
folder will open minimized. yeeeeahhhh
 
Back
Top