Saving file with current date

  • Thread starter Thread starter rglasunow
  • Start date Start date
R

rglasunow

Is it possible to save my active workbook with the current date in it.
I am currently using the following code but it is not working

ActiveWorkbook.SaveAs Filename:="C:\Excel Test\Test & Format(Date
"mm-dd-yyyy") & .xls"

Thank you, so far you all have been a huge help to me!!
 
You're missing some quotes

ActiveWorkbook.SaveAs Filename:="C:\Excel Test\Test" &
Format(Date,"mm-dd-yyyy") & ".xls"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top