I have a macro which saves a file as a pdf., but would like to adjust it to include the current date in the filename. The code is below.
Sub SaveAsAuto()
Application.ScreenUpdating = False
Sheets("Primary Bank").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...