Saving a monthly report using Visual Basic
?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?
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"
--
David
|