Open Workbook - Password
 

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

Open Workbook - Password
 

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

Open Workbook - Password
 

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



any clues?

Open Workbook - Password
 

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