Try this
msgbox Format(Now(), "mmddyyyy")
ChDir "H:\Desktop\Pipeline\Blank Manager Pipelines" ActiveWorkbook.SaveAs Filename:= _ "H:\Desktop\Pipeline\Blank Manager Pipelines\BASSANI_" & Format(Now(), "mmddyyyy") & ".xlsx", _ FileFormat:=xlOpenXMLWorkbook
Bookmarks