Cool beans.
************
Anne Troy
www.OfficeArticles.com
"excelnewbie" <excelnewbie@discussions.microsoft.com> wrote in message
news:0999E4BD-484E-4E5D-ACF2-FBFD3E8DBB49@microsoft.com...
> 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" <excelnewbie@discussions.microsoft.com> wrote in message
>> news:9E0F0511-106C-4E91-BBA9-4548BFA2C7E8@microsoft.com...
>> > 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?
>>
>>
>>
Bookmarks