You can use this: http://vbaexpress.com/kb/getarticle.php?kb_id=38
And just leave this part off of the one line of code: & " " & Format$(Date,
"mm-dd-yyyy")
************
Anne Troy
www.OfficeArticles.com

"excelnewbie" wrote in message
...
Is it possible to have the contents of a cell auto save into the file
name?
E.g. if I have a clients name in a cell, I want the name of the file to
change to match that cell so that when I quicksave the file name changes
to
match that particular cell.
Make sense?