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).



Posted by rm on December 24, 2001 1:12 AM

haha! answered my own question...(kinda)

...well, I didn't ACTUALLY answer it, but I found the answer on another page...

http://www.mrexcel.com/tip040.shtml