Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
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 -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
Sorry, thought you said maximised
still use this code and it should minimise it -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200603/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
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. -- Regards, Tom Ogilvy "MSweetG222" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scheduled Tasks & Starting Excel in a Minimized Window
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 "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "MSweetG222" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Windows Scheduled Tasks | Excel Discussion (Misc queries) | |||
What is correct syntax when using Scheduled Tasks? | Excel Discussion (Misc queries) | |||
Open workbook with scheduled tasks? | Excel Programming | |||
Running Macro in Minimized Excel Window | Excel Programming | |||
starting macros via scheduled tasks | Excel Programming |