Hello,

I have a macro that opens a workbook that has a password to open and then saves a new copy of the file. The problem is, the newly saved file still has the same password to open, but I need it removed. The closest thing I have found is ActiveWorkbook.Unprotect Password:="mypassword." I tried this but it did not work for a password to open (I assume it unprotects workbooks that are only partially protected).

Here is the relevant snippet from what I am currently using:

Workbooks.Open Filename:=OpenPaths(i), _
      Password:="mypassword", UpdateLinks:=0

ActiveWorkbook.SaveAs Filename:=SavePaths(i), _
      FileFormat:=xlOpenXMLWorkbook
Any help would be greatly appreciated. Thanks in advance!