View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ant
 
Posts: n/a
Default Saving a monthly report using Visual Basic

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.