Automate Excel File Names

DeadSeaSquirrels

Senior member
Jul 30, 2001
515
0
0
Is there a way to make the default file that a new excel file, started from a custom template, will be saved as. Namely one that will correspond to some cell on the spreadsheet.

So lets say I create a template where it is uses a network counter, so it updates say my invoice number everytime I create a new invoice using that template. Is there a way to make the default save name "Invoice [invoice #] [year].xls" or something like that?

Please if anybod knows.
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
yes you can...I will update later this evening with details....