Hey folks,

I've used a similar script to the one below in a previous project. This time I amlooking at adding this piece to a fromatting macro.

I've got a 'Compile Erroe: Expected expression' on the ':='. Any ideas why?


    ActiveWindow.FileFormat:= _
    xlNormal, Password:="Stafffile", WriteResPassword:="Stafffile", ReadOnlyRecommended:=False _
    , CreateBackup:=False