Excel Reference - Startup Switches
(Page 3 of 6 )
As with most programs, you can start Excel from the command line (Start -> Programs -> Accessories -> Command Prompt). At the command prompt, type excel.exe to run Excel just as you would if you ran the program by selecting it from the Programs menu. When you run Excel from the command prompt, however, you have the option of adding startup switches that change how the program opens.
Table 4-4 lists the startup switches available to you for Excel (e.g., excel.exe /e).
Table 4-4. Startup switches
Startup switch | Description |
workbook path/file name | Open a specific workbook. |
/rworkbook path/file name | Open a specific workbook as a read-only file. |
/e | Prevent display of the Excel startup screen and a new blank workbook. |
/pfolder path/folder name | Specify the working folder. |
/s | Start Excel in Office Safe Mode, which runs the main program with no add-ins or templates. |
/aprogID | Starts Excel and loads the named add-in. |
/tworkbook path/file name | Starts Excel and loads the named file as a template. |
Wildcards in Filters and Searches When you need to find particular kinds of values in your worksheets, you can use the “Find and Replace” dialog box (opened to the Find tab page by clicking Home -> Find & Select -> Find, or to the Replace tab page by clicking Home -> Find & Select -> Replace) or filters. Excel extends your search power by letting you use wildcards, which are characters that can take on multiple values (for example, any letter or any character). Table 4-5 lists the wildcard characters you can use in Excel searches and filters.
Table 4-5. Excel wildcard characters
Character | Description |
? | Any single character (e.g., "fr?e" finds "frye" and "free"). |
* | Any group of characters (e.g., "f*" finds "frye", "fair", and "foul"). |
~ followed by ?, *, or ~ finds a question mark, asterisk, or tilde | "Frye~?" finds "Frye?". |
Next: Default File Locations >>
More Database Articles
More By O'Reilly Media
|
 This article is excerpted from chapter four of the Excel 2007 Pocket Guide, Second Edition, written by Curtis Frye (O'Reilly; ISBN: 0596514522). Copyright © 2007 O'Reilly Media, Inc. Check it out today at your favorite bookstore. Buy this book now.
|
|
