I can't figure out how to get the new code to work. I want to have visual basic detect when a folder does not exist and create the folder. I also want the code to reference the UNC server since each user migh have different drives mapped to the shared directory.

Old code:
MkDir "L:\PSGLRPTS\" & BusinessUnit & "\" & YearDate & MonthDate
ActiveWorkbook.SaveAs FileName:="L:\PSGLRPTS\" & BusinessUnit & "\" & YearDate & MonthDate & "\Yr" & ProjYear & "Proj.XLS", _

New code:
MkDir "\\server\sharefolder\PSGLRPTS\" & BusinessUnit & "\" & YearDate & MonthDate
ActiveWorkbook.SaveAs FileName:=""\\server\sharefolder\PSGLRPTS\" & BusinessUnit & "\" & YearDate & MonthDate & "\Yr" & ProjYear & "Proj.XLS", _