Try something like
ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") &
".xls"
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Ant" wrote in message
...
Every month I save a hardcopy version of a report into a
folder. I want to
run a macro to do this which amongst other things, names it
after the
respective month. ie in Jan the macro saves the hardcopy report
as
Report_Jan.xls. In February I want the macro to save it as
Report_Feb.xls.
etc.