VB Code to Open Password Protected Excel File

[pliskers]

Is there VB code to include the entry of a password to open a password protected Excel file? I tried recording the steps but the code that was recorded only showed the File-Open step without any reference to the fact that the password was entered.

Thanks in advance!

 

[Jonmo1]

Workbooks.Open "Path\Filename.xls", Password:="Jon", WriteResPassword:="Fred"

There are 2 possible passwords
Password is for Open
WriteResPassword is for Modify

 

[schielrn]

This link may help:

http://www.ozgrid.com/forum/showthread.php?t=56300

 

[Domski]

Workbooks.Open Filename:= "C:\johndoe.xls", Password:="Password"

 

[pliskers]

Awesome! Thanks for the quick reply!

 

[pliskers]

A follow up question: What would be the code to save a file with a specific password?

Thanks again!

 

[Domski]

ActiveWorkbook.SaveAs "C:\johndoe.xls", Password:="Password"

Dom