Thread: Open workbook with password.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
  
Posts: 425
Default Open workbook with 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

Reply With QuoteReply With Quote