I have some automated processes that use an Excel auto_open sub to kickstart various things. Excel is called from a batch file triggered by a Task from the Task Scheduler.
Since auto_open can be a pain (I don’t want it to run every time the spreadsheet is opened, only when triggered by the batch file), I have it first check whether Excel is minimized, and if so, run whatever it’s supposed to do.
I do this with this command from a command window (or, technically, a batch file):
start /min excel <file name>
In Excel 2010, no problem, it opened minimized (Application.WindowState = xlMinimized). Over the weekend, we were upgraded to Office 2013 and this no longer works.
If I type:
start /min winword
Word opens minimized. Same with PowerPoint, etc. However, Excel doesn’t. Maybe it’s related to how Excel now opens each window in its own instance?
Anyway, any ideas as to how to solve this problem? Either a more reliable way to open Excel minimized or some other neat workaround using auto_open?
I’m using Windows 7 and Office 2013. Thanks!