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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 23 Jun 2005 23:54 GMT

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

Reply to this Message

Dave Peterson - 24 Jun 2005 00:28 GMT

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.

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

Signature

Dave Peterson

Reply to this Message