Issue with VBA - Save as macro enabled workbook - address problem.

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

Hi Roy,
Thanks for the, the drive is W:
My original code contained the address

W:\LOGISTICS\Supervisor's\Housekeeping\Completed Checks

and was told it needed to be the way it currently is, but i will give it a shot now and try

regards

Hi Roy,
Sorry, ignore that, moment of monday madness, hadnt copied all of your code. now works lush.

Cheers again