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

D

Daniel

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

Dave Peterson

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.
 
Top