Removing password for a excel file using vba

Question

I have multiple excel workbook send to me everyday with password protected. Our procedure requires me to remove the password and save it in share drive. I believe the password is added by the sender using below

workbook.saveas password:="pw"

i have tried workbook.unprotect or workbook.saveas password:="" but this fail to remove the password. anyone know how i can automate this instead of manually removing the password?

Dave · Accepted Answer · 2019-09-20 09:28:40Z

1

You can change the password setting in the workbook before saving.

Option Explicit

Sub testPasswordRemoval()

    Dim wb As Workbook

    Set wb = Workbooks.Open(Filename:="C:\Temp\Book2.xlsm", Password:="pw")
    wb.Password = ""
    wb.SaveAs "C:\Temp\NewBook.xlsm"

End Sub

edited Sep 20, 2019 at 9:28

answered Sep 20, 2019 at 9:19

Dave

1,6431 gold badge9 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Removing password for a excel file using vba

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related