how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab.

how to automate opening a password protected excel file? e.g. a .xls that
has a password set in the security tab.

With no checking...

Option Explicit
Sub testme()
Dim Wkbk As Workbook
Set Wkbk = Workbooks.Open(Filename:="C:\My Documents\excel\book1.xls", _
Password:="hithere")
End Sub

The code has to "know" the password.


Daniel wrote:
>
> how to automate opening a password protected excel file? e.g. a .xls that
> has a password set in the security tab.

--

Dave Peterson