VBA Code - Macro to Save file as Previous Month and Year

[squeakums]

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

 

[Joe4]

Try this:

    Dim fname As String
    fname = "Z:\Monthly Issue Management\" & Format(DateAdd("m", -1, Date), "mmmm yyyy") & " - Wholesale Issues.xlsx"
    ActiveWorkbook.SaveAs Filename:=fname, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False