Launch Excel Using Command Prompt
There are many ways to start Excel using Command Prompt, but if you want to launch Excel in its normal state (that is, the same way that Excel launches when you click the shortcut), then there are two different ways to do that.
First, there’s the simple way. Open Command Prompt by typing “cmd” in the Windows Search bar and clicking the Command Prompt app from the search results.
Command Prompt will open. To launch Excel, type this command and press Enter:
start excel
Excel should launch immediately.
Another way to open Excel is by locating the directory that holds the excel.exe file, changing to that directory in Command Prompt, and then running a simple command.
To locate the excel.exe file, you’ll need to be in the Program Files directory in Command Prompt. You can use the cd
command to change the directory. Type this command in Command Prompt, and then press Enter:
cd\"program files"
You’ll now be in the Program Files directory. Next, you need to find out in which directory the excel.exe file is located. To do so, run this command:
dir excel.exe /s
The directory of the excel.exe file will be returned.
Now that you know the directory where excel.exe is located, navigate to that directory. Since we’re already in the Program Files directory, we can omit that from the next command. In our example, we’d run this command:
cd Microsoft Office\root\Office16
Now that you’re in the correct directory, all that’s left to do is to type excel
in Command Prompt and press Enter.
Excel will now open. However, the main purpose of launching Excel from Command Prompt is so that you can control how it opens, and you do that by appending the various switches and parameters that are available to the command.
Excel Command Line Switches and Parameters
Here’s a list of command switches provided by the official Microsoft Office support site. Add these to the end of the start excel
command in Command Prompt.
Switch and Parameter | Description |
workbook path | file name No switch is required. | Opens the target file. Example: start excel “c:\Example Folder\file_name1.xlsx” or start excel http://MySite/file_name1.xlsx |
/r workbook path | file name | Opens the target workbook as read-only. Example: start excel /r “c:\Example Folder\file_name1.xlsx” or start excel /r http://MySite/file_name1.xlsx |
/t workbook path | file name You can also use /n instead of /t to achieve the same result. | Opens the target file as a template. Example: start excel /t “c:\Example Folder\file_name1.xlsx” or start excel /t http://MySite/file_name1.xlsx |
/e or /embed | Prevents the Excel startup screen from appearing and a new blank workbook from opening. |
/s or /safemode | Starts Excel in Safe Mode. This launches Excel without any additional add-ins, templates, or other customizations. It’s helpful when troubleshooting problems in Excel. |
/m | Creates a new workbook that contains a single XLM macro sheet. |
/a progID | Loads the Automation add-in specified by the progID of the add-in. Example: start excel /a MyProgId.MyProgID2.1 |
/x | Starts a separate process of Excel. |
Using these commands, you can open Excel in a number of different ways.
No comments:
Post a Comment