Saving a monthly report using Visual Basic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try something like

ActiveWorkbook.SaveAs Filename:="Report_" & Format(Now,"MMM") &
".xls"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
So...would that save it as FEB if it is actually February? And if I save it
today for example it would save it as MAR? If so, I really need it to save to
a month that I can manually select, for example, I need to save it as FEB
today, not MAR (It's a month end report you see, so will always be a month
behind the actual month). Can I point the name of the month to a cell that
has data validation?
 
=?Utf-8?B?QW50?= wrote
So...would that save it as FEB if it is actually February? And if I
save it today for example it would save it as MAR? If so, I really
need it to save to a month that I can manually select, for example, I
need to save it as FEB today, not MAR (It's a month end report you
see, so will always be a month behind the actual month). Can I point
the name of the month to a cell that has data validation?
Click to expand...

If you have a date that reflects that month somewhere in the report you can
include part of that cell's value in the filename. i.e.:

ActiveWorkbook.SaveAs Filename:="Report_" & Format(Range("g2"), "mmm") &
".xls"
 
Back
Top