VBA Code to Save into a Network Drive

[EdwardOcampo]

Hi!

Part of my code is not working. The part that is not working is saving the file into an specific file in a network drive.

Here is the VBA that I'm using.

ChDir "G:\NARS Planning\Open Order Reports"
ActiveWorkbook.SaveAs Filename:="NARS Open Order Report " & Format(Date, "mm.dd.yy") & ".xlsx", FileFormat:=xlOpenXMLWorkbook

Any input will be greatly appreciated.

Thank you.