I have some existing code which takes two cell values and combines them together to make a file name, saves the document and exits Excel.
ActiveWorkbook.SaveAs Filename:=Sheets("Input").Range("E9").Value & " " & Sheets("Input").Range("E11").Value & ".xls"
    If Application.Workbooks.Count = 1 Then
Application.Quit
End If
End Sub
Currently the file saves to my local PC, but i would like to save to a newtwork drive with the following path - "N:\COA Data\"

I have tried to search, but but i'm having trouble expanding my current code with the dynamic file name to include the network path.
Whenever i edit the "ActiveWorkbook.SaveAs Filename:=Sheets" part of the code to specify a path i get errors.

Is this at all possible, can anyone help?