How to Start Microsoft Excel from the Command Prompt - WindowsTips.net - Windows Tips and Tricks with Geek

Saturday, January 29, 2022

How to Start Microsoft Excel from the Command Prompt

 Microsoft Excel Logo

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.

Type "cmd" in the Windows Search bar and click Command Prompt.

Command Prompt will open. To launch Excel, type this command and press Enter:

start excel

Type "start excel" in Command Prompt.

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"

Change to the "Program Files" directory in Command Prompt.

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.

The directory of Excel returned in Command Prompt.

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

Change to the directory that contains the excel file.

Now that you’re in the correct directory, all that’s left to do is to type excel in Command Prompt and press Enter.

Type "excel" in Command Prompt.

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 ParameterDescription

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 /embedPrevents the Excel startup screen from appearing and a new blank workbook from opening.
/s or /safemodeStarts Excel in Safe Mode. This launches Excel without any additional add-ins, templates, or other customizations. It’s helpful when troubleshooting problems in Excel.
/mCreates a new workbook that contains a single XLM macro sheet.
/a progIDLoads the Automation add-in specified by the progID of the add-in.

Example:

start excel /a MyProgId.MyProgID2.1

/xStarts a separate process of Excel.

Using these commands, you can open Excel in a number of different ways.

No comments:

Post a Comment