D Daniel Jun 23, 2005 #1 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.
D Dave Peterson Jun 24, 2005 #2 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.
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.
