Search the Community
Showing results for tags 'workbook protection'.
How do I turn off a password protected workbook. Obviously I have the password. I am trying to make a copy of the protected workbook and make the new copy unprotected. Thank you very much set xlApp = CreateObject("Excel.Application") Set objWorkbook = xlApp.Workbooks.Open("C:\mypath\..\..\protected.xlsx") xlApp.Visible=TRUE Set targetSchedule = xlApp.Workbooks(1) targetSchedule.SaveAs ("C:\mypath\..\..\..\uprotected_copy.xlsx") Dim myPass myPass = "12345678" targetSchedule.Unprotect password:=myPass