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

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

"J.W. Aldridge" wrote:

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

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



any clues?

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.

--
Regards,
Bill Renaud