Saturday, March 24, 2012

How to Use Command Line Parameters in Microsoft Excel


1. Open a command prompt by clicking 'Start,' choosing 'Run,' entering 'cmd' and clicking 'OK.'
2. Type 'excel' on the command prompt. Enter a space. Do not press Enter yet.
3. 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.
4. Press enter. This will cause Excel to load. After you are done using Excel, you can close your command prompt window.

Blogger news