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

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open file password 13
Excel Protection 2
Problem In Opening Excel: Thoughts On ? 2
Password protect doc vs encrypt with password 1
Links to password protected workbooks 9
Pivot table - connection to Excel file with password 3
help me tor recover excel 2007 (file to open) password 1
password protection 1

Back
Top