Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
Excel 2000 Auto Save | Excel Worksheet Functions | |||
auto save in office excel 2003 | Excel Discussion (Misc queries) |