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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>>
>>
>>