Hello all,

The code below saves the file to a network drive.

PHP Code: 
    ActiveWorkbook.SaveAs Filename:= _
        "Q:\Logistics\Team Logistics\PURA upload sheet\PURA upload sheet.xls", _
        FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
        ReadOnlyRecommended:=False, CreateBackup:=False 
It has worked great but all the sudden new employees have an "S" not a "Q" in front of the first character of the code. The macro breaks if a new employee uses it. Is there a way I can have it save to either "S" or "Q" in the first line of the code? Or is there another way around this problem?

Thank you so much in advance for time.

Eddie