Gb,

Off the top

ActiveWorkbook.SaveAs Filename:= Activesheet.Range("A10") &
Format(Date,"yyyy-mm-dd")

--

HTH

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

"gfinch " wrote in message
...
I would like to create a macro that will name a file and save it so that
the name is the same as the contents of cell A10 + today's date. Is
this possible?
Thanks for all your help.
Gib


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