[RESOLVED] NewPassword command in Excel VB

[mikeymay]

Does 'NewPassword' command have any use in Excel VB?

My problem is that I have a 'Read-Only' template user form and this form is populated with various bits of data.

I want to then save the user form with the data to another folder but not as read only.

My code as it stands now (saving amended form as 'Read-Only') -

With activeworkbook
             .SaveAs ("S:\Finance\Finance\Form 19 Jan 06")

I know I can add/remove the password by specifying after file name, but before the password comes FileFormat. Do I have to specify this as well or can I use -

.SaveAs ("S:\Finance\Finance\Form 19 Jan 06"),"",

to remove the password.


Thanks

[RobDog888]

It should not be saved with a password unless specified. But if it doesnt then use a vbNullstring or "".

ActiveWorkbook.SaveAs Filename:="C:\Test.xls", Password:="123"
 
'Or
ActiveWorkbook.SaveAs Filename:="C:\Test.xls", Password:=""

[mikeymay]

thanks