Open .xls from CMD with password

[fjruiz412]

Hi

I need to open in CMD command line, a 2010 excel workbook with open password

same like this:

[FONT=&quot]C:\Program Files\Microsoft Office\OFFICE11\excel.exe [/FONT][FONT=&quot]C:\Documents and Settings\Paul\My Documents\libro1.xlsx password="1234"

I don´t Know how do this

thanks a lot

best regards[/FONT]

 

[Scott Huish]

I did a little research and I don't believe it's possible to pass the password to Excel via command prompt.

However, there is a shorter way to start excel from the command prompt:

start excel.exe "C:\Documents and Settings\Paul\My Documents\libro1.xlsx"

 

[jwalkerday]

One way is to open a separate excel file with some auto-open VBA code to open your excel file with password-

[FONT=&quot]Sub Auto_Open()[/FONT]
[FONT=&quot]  Workbooks.Open Filename:="myfile.xls", Password:="mypassword"[/FONT]
[FONT=&quot]  ThisWorkbook.Close SaveChanges:=False[/FONT]
[FONT=&quot]End Sub
[/FONT]

 

[fjruiz412]

ok
thanks
regards