Can I get excel to auto save details from a cell into the doc nam.

[Guest]

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?

 

[Anne Troy]

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

 

[Guest]

Thank you VERY much
Works like a charm!

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

 

[Anne Troy]

Cool beans.
************
Anne Troy
www.OfficeArticles.com