View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale Walker Dale Walker is offline
external usenet poster
 
Posts: 1
Default Saving with a filename already in a cell

I need to create a way to automatically save the workbook as a particular
filename with the addition of the month/date already entered in a cell. When
the original blank is filled out and my "update" macro is run, the file will
be saved as "Monthly Report" followed by the addition of the information in
cell E4 (the date and year). ('Monthly Report Oct 2004') How do I write
this in my macro?

Thanks