I have the following code in place now but instead of overwriting the pdf in the file location I want to add a date to the name. That way I can go back and see previous file that have been ran before. I am completely green to this so any help or advise would be welcomed.
ChDir "S:\WWWW\To_MdSt"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"S:\WWWW\To_MdSt\XXXX\OOOO", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
ChDir "S:\WWWW\To_MdSt"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"S:\WWWW\To_MdSt\XXXX\OOOO", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True