Hi Thomas
Assuming date is today's:
Dim NameOFile$
NameOFile = Format(Date, "mm-dd-yyyy")
ThisWorkbook.SaveAs NameOFile & ".xls"

Regards
Pascal

"Thomas L" a écrit dans le message de
...
Hello. Quick question. I have created a macro do create a report for me.
I want it to save the file to a specific drive (ie.
\\pkcfp001\tlynch07\Sales Distribution Reports\). When the original file is
created, the name is given as SalesBaseReport04112004.xls where the 04112004
represents the date for the data in the file. If possible, I would like it
to take just the date portion and create a filename based on the date in
04.11.2004.xls or 04-11-2004.xls format. The filename will change on a
daily basis with the date. Is it possible to make this happen?