VB and VBA Users Source Code: Excel Command Line Switches
[
Home
|
Contents
|
Search
|
Reply
| Previous | Next ]
VB/VBA Source Code
Excel Command Line Switches
By:
Andrew Baker
Email (spam proof):
Email the originator of this post
Date:
Sunday, November 12, 2000
Hits:
884
Category:
Office
Article:
Listed below are the Excel Command Line Switches: Switch Function ---------------------------------------------------------------------- /automation Forces Microsoft Excel 97 to start without loading add-ins, templates, or processing files in the XLSTART folder or the Alternate Startup File Location. You can use this switch to perform a "clean-boot" of Microsoft Excel 97. (See also the /s switch, shown below.) Example: /automation /e, Forces Microsoft Excel to start in embedded mode. Use /embedded this switch when you want to start Microsoft Excel without creating a new workbook (Book1). Example: /e, /embedded /i Forces Microsoft Excel to start with a maximized window. Previously saved window size settings are ignored. Example: /i /m Forces Microsoft Excel to create a new workbook that contains a single Microsoft Excel 4.0 macro sheet. Example: /m /o Causes Microsoft Excel to re-register itself. Specifically, the following key is rewritten in the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel NOTE: If this key contains invalid values, they are not corrected by using this switch. This switch only replaces missing values. Example: /o /p <folder> Sets the active path to a different folder. Use this switch to set the active path to a folder other than the default file location. Example: /p "C:\Windows" /r <filename> Forces Microsoft Excel to open the specified file in read-only mode. Example: /r "C:\My Documents\Test.xls" /s Forces Microsoft Excel to bypass all files in the Xlstart and Alternate Startup Files folders. Use this switch when you want to start Microsoft Excel in Safe mode. Example: /s /regserver Forces Microsoft Excel to register itself and then quit. Use this switch when you want Microsoft Excel 97 to rewrite all of its registry keys and reassociate itself with Microsoft Excel files, such as workbooks, charts, and add-ins. Example: /regserver /unregserver Forces Microsoft Excel to unregister itself and then quit. Example: /unregserver
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
