B
Bryan Linton
I've created a template called "Field Rating - .xls". I chose that filename
so when users try to save new workbooks created from that template, they'll
get a default filename of "Field Rating - 1.xls". Then they can simply
replace the "1" with the customer's name and save.
My question is, is there a way to automatically incorporate the contents of
a cell in the filename on first save? That way, users could open the "Field
Rating - " template, enter the customer name in a particular cell and use
the workbook, then save it without having to modify the filename. When the
"Save As..." box pops up, the filename would automatically read, for
example, "Field Rating - Mary Lennox.xls".
Not sure how to go about this...google searches haven't been fruitful.
Btw, using Office 2000, although soon to migrate to 2003.
Thanks in advance,
Bryan
so when users try to save new workbooks created from that template, they'll
get a default filename of "Field Rating - 1.xls". Then they can simply
replace the "1" with the customer's name and save.
My question is, is there a way to automatically incorporate the contents of
a cell in the filename on first save? That way, users could open the "Field
Rating - " template, enter the customer name in a particular cell and use
the workbook, then save it without having to modify the filename. When the
"Save As..." box pops up, the filename would automatically read, for
example, "Field Rating - Mary Lennox.xls".
Not sure how to go about this...google searches haven't been fruitful.
Btw, using Office 2000, although soon to migrate to 2003.
Thanks in advance,
Bryan