Saving file with current date
 

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!!

--
Message posted from http://www.ExcelForum.com

Saving file with current date
 

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)

"rglasunow " wrote in message
...
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!!!


---
Message posted from http://www.ExcelForum.com/

Saving file with current date
 

You da man Bob!!! It worked. thank yo

--
Message posted from http://www.ExcelForum.com