For what password are you being prompted?

Is it to open the workbook--or to update the workbook?

If you're being prompted to allow write access:

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

And you have to know the password and type it (them?) into your code.


Stephen C wrote:

If i set an incorrect password in the code it has the same affect.

It seems to ignore the password.

Any ideas??

How can you get the password to show in the code? when i have turned on the
macro recorder then opened the file inputting the password it does not list
it in the code.

"Dave Peterson" wrote:

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


--

Dave Peterson