VBA to upload data to a file in a network folder

Hi All,

Below is a part of the macro that we currently use to upload data from the New Form tab onto the Data tab of the same file:

Sub Save_Data()
    Application.ScreenUpdating = False
    Dim srcWS As Worksheet, desWS As Worksheet, bottomA As Long
    Set srcWS = Sheets("New_Form")
    Set desWS = Sheets("Data")
    bottomA = desWS.Range("A" & desWS.Rows.Count).End(xlUp).Row + 1

How can I make it so that the macro will now upload the data to a file saved in a network folder? For example, the path is \\phil.company.com\cmp\dept_folder\program\Raw files\Evaluations and the filename is Raw Data.xlsb, and will have the same tab "Data".

Thank you.