Hi Guys,
I have a workbook that I have password encrypted. (I know the password!)
I have a vba module that strips out the sheets with the data I want to keep private so that the remainder can be shared with others. The problem is that when this new version saves it still has the password encryption to open the workbook. Is there a way to remove it?
I was thinking something like:
or
But the syntax for SaveCopyAs seems to only allow filename?
Can anyone help?
I have a workbook that I have password encrypted. (I know the password!)
I have a vba module that strips out the sheets with the data I want to keep private so that the remainder can be shared with others. The problem is that when this new version saves it still has the password encryption to open the workbook. Is there a way to remove it?
I was thinking something like:
Code:
ActiveWorkbook.SaveCopyAs ThisWorkbook.Path & "\" & NewName & ".xlsm", FileFormat:=52, Password:=""
Code:
ActiveWorkbook.SaveCopyAs ThisWorkbook.Path & "\" & NewName & ".xlsm", FileFormat:=52, Password:=FALSE
But the syntax for SaveCopyAs seems to only allow filename?
Can anyone help?