default excel filename save as
Posted by rm on December 23, 2001 11:47 PM
First off--thanks to Mark O. for the expert advice on auto-naming worksheet tabs based on a cell's value--(it never ceases to amaze me what excel can do given the proper knowledge.)
And now...the query:
Whenever you create a new workbook, the default "save as" name is "Book 1," "Book 2," etc. With the workbooks I am creating for a particular folder, I would like the default "save as" name to be based on--you guessed it--a cell's value!
Question 1: Is this possible?
Question 2: How can it be achieved?
Merry Christmas & Happy New Year...rm
p.s. Word does this automatically, assuming that line 1 of your document is the default "save as" name...so I assume there must be a way for excel to do the same, (but with a little sleight of hand trickery, maybe).