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

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?

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?

Thank you VERY much :)
Works like a charm!

"Anne Troy" wrote:

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?

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

"excelnewbie" wrote in message
...
Thank you VERY much :)
Works like a charm!

"Anne Troy" wrote:

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?