vba code for opening password protected workbook
Sub OpenPassword()
Dim wbk As Workbook
Application.DisplayAlerts = False
Set wbk = Workbooks.Open(Filename:="", _
UpdateLinks:=True, _
Password:="")
With wbk
.Save
.Close
End With
Set wbk = Nothing
End Sub
|