Below I have a sub routine that needs to be modified to enable multiple users
with different paths to the same file location on a network drive to save the
file using this macro. The only difference in location is the letter of the
drive. On my computer it is identified as "N:", but on another user's
computer it could be identified as any letter of the alphabet. Any simple
solutions to this issue?

Sub saveNew()
yyyy = Format(Range("M1").Value, "yyyy")
mmddyyyy = Format(Range("M1").Value, "mm-dd-yyyy")
mmddyy = Range("M2").Value

ActiveWorkbook.SaveAs Filename:="N:\FOLDER\FOLDER 2\folder 3\" & yyyy & "\"
& mmddyyyy & " Distribution" & "\Rates " & mmddyy & ".xls"

End Sub