Password Protected File

[DWB82]

Hi,

Is there any reason why this should not work:

Workbooks.Open Filename:="S:\Stafford\Training Files\17. New_Training_Tracker\Template-Staff-Training-Manager-Database V1.2.xlsm", Password:="password", writerespassword:="password"

I have also tried:

Workbooks.Open Filename:="S:\Stafford\Training Files\17. New_Training_Tracker\Template-Staff-Training-Manager-Database V1.2.xlsm", writerespassword:="password", Password:="password"


I am having trouble findinding any other macro than the above.

Each time i run the Macro it's prompting me to enter the password. And i've verified that the password entered above is the same password i use to manually open the file.

any assistance is greatly appreciated.

thank you.​

 

[RoryA]

That code is correct. Are you 100% certain that the password you entered is correct, and are you sure it's the password for that file that you are being prompted for, and not say a linked file?

 

[DWB82]

Hi

Thank you for your response. I am 100% sure that the password is correct. When the password is entered manually the file then opens up without any further prompts eg open as ReadOnly.

I am positive that the password is for that file as no other files are linked to it etc.

Thanks again for any assistance that can be given

 

[RoryA]

Which password is actually set? One to open, or one to modify?

 

[DWB82]

it is a password to open the file that is set.

 

[RoryA]

And it's definitely a standard Excel open password, not something created by the code in that file?

 

[DWB82]

the password is one that was added by going to:
File
save As
Tools
General Options
the password has then been entered on the top line "password to Open"

 

[RoryA]

If that's the only one, you don't need the writerespassword:="password" part, but it should work with or without that. Also, if the password were wrong to open it, you should get an error, not a prompt.