What code can I use to save file as previous month and year in the title? Currently, I have to save as manually to the previous month and year. I'd like for it to save as 'January 2025 - Wholesale Issues' or whereever the previous month lands. I usually run this report around the 4th or 5th of the current month. So, maybe like -10 days for mmmm yyyy
ActiveWorkbook.SaveAs Filename:= _
"Z:\Monthly Issue Management\January 2025 - Wholesale Issues.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
ActiveWorkbook.SaveAs Filename:= _
"Z:\Monthly Issue Management\January 2025 - Wholesale Issues.xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False