Start Excel with command line and parameters

Question

I want to create a Windows script to execute excel and open a file p and using the password

Example

Start excel c:\Documents\ExcelFile.xls

but also I want to add the password

Start excel c:\Documents\ExcelFile.xls Password

But when I try to do that is not recognized

EylM · Accepted Answer · 2019-12-10 18:24:06Z

4

You can create a PowerShell script to perform that using Workbook Open function.

$path = "c:\temp\1.xls"
$password = "123"
$excel = New-Object -ComObject Excel.Application
$workbook = $excel.Workbooks.Open($path,$false,$false,5,$password)
$excel.Visible = $true

Save the script to a text file OpenExcel.ps1.

Usage:

powershell -file OpenExcel.ps1

answered Dec 10, 2019 at 18:24

EylM

6,1332 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Link Dvamp AcMo Over a year ago

Thank you im going to test :D

Pᴇʜ · Accepted Answer · 2019-12-10 20:03:53Z

3

Excel has no command line switch to submit a password.
See Command-line switches for Microsoft Office products

But you can use a VBScript StartExcel.vbs instead of a batch file StartExcel.bat to do that:

Set oExcel = CreateObject("Excel.Application")
Set oWorkbook = oExcel.Workbooks.Open("c:\Documents\ExcelFile.xls", 0, 0, 5, "<myPassword")

edited Dec 10, 2019 at 20:03

answered Dec 10, 2019 at 17:45

Pᴇʜ

57.9k10 gold badges55 silver badges75 bronze badges

1 Comment

Link Dvamp AcMo Over a year ago

Thank you I'm going to test :D

Collectives™ on Stack Overflow

Start Excel with command line and parameters

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related