Open Workbook - Password

[J.W. Aldridge]

Got this macro, but it still prompts for password.


Any clues as to why?


Sub Macro7()
'
' Macro7 Macro


Workbooks.Open Filename:="X:\FHI Share\pcp\NEW PCP DATA.xls",
PASSWORD:="pcp123"


ActiveWorkbook.Save
ActiveWindow.Close


End Sub

 

[AccessHelp]

May be, the password for "NEW PCP DATA.xls" is not "pcp123". Are you sure it
is "pcp123"?

 

[J.W. Aldridge]

Super certain. (I created it and use it every hour.)



any clues?

 

[Bill Renaud]

Does the workbook have passwords for both Open and Modify? If you entered
passwords for both, then your macro is only supplying the first one. You
may also need to supply the WriteResPassword parameter in the Open method.