Morning happy campers,
I'm not entirely sure if you can sort this -

I have the following code that should copy the selected tab, paste into new workbook, save this workbook to the designated location, then close it.
Sub Macro5()
'
' Macro5 Macro
'

'
    Sheets("H.K Template").Select
    Sheets("H.K Template").Copy
      newFile = Application.UserName & " - " & Format$(Date, "dd-mmm-yy")
    ChDir _
"\\emea\uk\MAG_GROUP\division\WHOUSE\LOGISTICS\Supervisor's\Housekeeping\Completed Checks"
    ActiveWorkbook.SaveAs Filename:=newFile
      "\\emea\uk\MAG_GROUP\division\WHOUSE\LOGISTICS\Supervisor's\Housekeeping\Completed Checks"
        FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
    ActiveWindow.Close
End Sub
However, the following line is highlighted in red.
      "\\emea\uk\MAG_GROUP\division\WHOUSE\LOGISTICS\Supervisor's\Housekeeping\Completed Checks"
        FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Would anyone be able to have a stab at this for me?

Regards, galvinpaddy