I tried useing the below script within the 'Save file' part of the production script but I get an 'Compile Error: Else without If' and I cant see why.
Any idea?
If file_name = "Staff Business" Or file_name = "Staff Business Ref S" Then Windows("" & file_name & " 15+ DPD Retail & NonRetail " & Thisweek & ".xls").Activate.Save FileFormat:= _
xlNormal, Password:="Stafffile", WriteResPassword:="Stafffile", ReadOnlyRecommended:=False _
, CreateBackup:=False
Else
End If
ActiveWorkbook.Save
ActiveWindow.Close
Bookmarks