VBA code to remove password from workbook

[meme]

I'm trying to overwrite a number of files and remove the workbook password

ActiveWorkbook.SaveAs Filename:="name of file.xls", _
FileFormat:=x1normal, Password:="", writerespassword:="", ReadOnlyRecommended:=False, CreateBackup:=False

this code doesn't remove the password, I've searched the net and can't find any help on this

 

[prajul89]

Just record a macro while removing password from a workbook manually and see what is the codes.

 

[meme]

I didn't think that would work but I tried it and it and it showed that I'd got one letter wrong in my code, thanks for your help prajul89