Opening Excel file that requires password to Open

[DWB82]

Hi All

I am hoping that someone can help me. I am attempting to open an excel file which needs a password at start up.

I have tried using the code below:

"Sub OpenWbWithPassword()
Application.DisplayAlerts = False

Workbooks.Open Filename:="S:\Site\Training Files\Training_Tracker\Template.xlsm", Password:="123"

Application.DisplayAlerts = True

End Sub"

When this code is ran I get a notification box titled password. This box details the file name and that the file is protected. The protection was added to the file by going through the save as option, selecting tools, general Options and entering the password in to the password to open box.

I have been searching for a while now and cant seem to find a way around the issue. Can any one please help with this.

Thank you in advance

Dominic

 

[footoo]

Try :

[COLOR=#333333]Sub OpenWbWithPassword() [/COLOR]
[COLOR=#333333]Application.DisplayAlerts = False[/COLOR]

[COLOR=#333333]Workbooks.Open Filename:="S:\Site\Training Files\Training_Tracker\Template.xlsm", Password:="123"[/COLOR][COLOR=#ff0000], Password:="123"[/COLOR]

[COLOR=#333333]Application.DisplayAlerts = True[/COLOR]

[COLOR=#333333]End Sub[/COLOR]

 

[footoo]

Or this :

Sub OpenWbWithPassword()


Application.DisplayAlerts = False


Workbooks.Open Filename:="D:\Documents\t.xlsm", Password:="123"[COLOR=#ff0000], WriteResPassword:="123"[/COLOR]


Application.DisplayAlerts = True


End Sub

 

[DWB82]

Hi

Thanks for the quick reply. When I try entering the second password argument I get the error message "Named argument already specified". when I use writeResPassword the password box still loads up.

I am unsure if this will help but I am currently using excel 2016. The password was applied to the file using excel 2007.

Thanks again for the suggestions

 

[footoo]

Have you tried re-setting the password (i.e. remove the password(s) and set again) ?

 

[DWB82]

Yes removed the password from the file and saved it down, then re-applied the password to the file and attempted to run the macro again.

 

[footoo]

Perhaps you can find something here :
https://www.google.com/search?rlz=1.....1..gws-wiz.......0i71j35i304i39.42xi0hezJoc