Month - 1

[Loopy86]

Hi

How can I get my macro to save as the previous month??

Daily isnt a problem, I have used today()-1

I would just like it to save as March?

Thanks everyone

 

[VoG]

Try like this

ActiveWorkbook.SaveAs Filename := Format(DateAdd("m", -1, Date), "mmmm") & ".xls"

 

[Loopy86]

Hmmmm Thank you for replying BUT
I have another problem....

ActiveWorkbook.SaveAs Filename:="C:\Users\MyName\Desktop\Sales Activity\_ Monthly detail" Format(DateAdd("m", -1, Date), "mmmm") & ".xls"

The red line, I dont know what to put before it. I tried a comma but it didnt work, and I put it on a new line, where it suggested an '=' instead of a '&'

 

[VoG]

Try

ActiveWorkbook.SaveAs Filename:="C:\Users\MyName\Desktop\Sales Activity\_ Monthly detail\" & Format(DateAdd("m", -1, Date), "mmmm") & ".xls"

 

[Loopy86]

Great - It worked!!!!!

Thank you very much VoG