automatically saving a workbook as today's date

[rsj1]

I have set up a template and run a macro that copies information fro
one workbook to another, then saves the changes and then closes. Thi
is fine, but before the workbook closes I am trying to get the macro t
rename the template with today's date, but without success. I have pu
=today() in cell a1 and try to get the vba to look at this cell befor
closing but it just saves the template as (a1).xls instead of today'
date.
Does anyone know what I am doing wrong.
Your help will be gratefully received

regards


Steve Jackso

 

[JE McGimpsey]

One way:

ActiveWorkbook.SaveAs Filename:=Format(Date, "dd-mm-yyyy.xl\s")