Excel Macros Password

[n4tl]

Hi there,

i need to remove the password protection of the macros in about 1000 excel files. I KNOW the password, it just takes too much time to do it by hand. Is there a way to do this automatically?
thanks

 

[GlennUK]

Is it the same password for all files? Do you have a list of the files? Do you know how to write loops in VBA?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[n4tl]

Yes, its the same password for all files.
I have a list, and i know how to write loops in VBA.

 

[GlennUK]

Put the list of files in a sheet. Write a loop to get each cell in the list, and use it's contents to open the file ...

Application.DisplayAlerts=False
For Each c in Range("MyList")
     Workbooks.Open FileName:=c.Value, Password:="mypwd"
     ActiveWorkbook.SaveAs FileName:=c.Value, Password:=""
     ActiveWorkbook.Close
Next

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.