How Do You Use Command Line Parameters In Microsoft Excel?
If you’re an Excel power-user–or aspire to be one–you need to know about Excel’s command line switches. Whether for business or pleasure, Excel can help you get things done and using command line switches can help you get them done faster. Excel has a variety of switches that let you control how it starts and what files it loads when it does. Open a command prompt by clicking “Start,” choosing “Run,” entering “cmd” and clicking “OK.” Type “excel” on the command prompt. Enter a space. Do not press Enter yet. Type any command line switches you’d like to use, separating them with spaces. “/r fileName.xls” will open fileName.xls in read-only mode. “/t fileName.xls” will create a new document, using fileName.xls as a template. “/s” will cause Excel to start in “safe mode,” which prevents any start-up scripts from loading. You can see the full list of commands at the Microsoft Office page devoted to the topic. Press enter. This will cause Excel to load. After you are done using Excel, you
