Re: Excel macro to open a password protected workbook

When I do this, the workbook either opens successfully or I get a runtime error
that says I supplied the wrong password.

And I think that not recording the password is a security measure. If I'm using
your pc to open a top secret workbook and you turned on the macro recorder, then
you could get the password by looking at the recorded code.



Stephen C wrote:

I have a macro that will open an Excel workbook, The workbook is password
protected and therefore promts me for the password.

I would like the macro to automatically fill in the password and open the
file.

I have tried adding the password to the vba code but it still asks for the
password.

My code is as follows

Workbooks.Open Filename:= _
"C:\Settings.xls", Password:="1234"

I have tried recording a macro while opening the file and entering the
password but it does not show the password in the code.

I am using Windows XP SP2 with Excel 2000 SP3

--

Dave Peterson
.

Relevant Pages