Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving Excel file sequentially
I have a "template" Excel workbook that, whenever I save it, it must be saved
with a unique and sequential file name. How can I achieve this by means of macros or is there any other way of automating this function? |
#2
|
|||
|
|||
Saving Excel file sequentially
You'll have to keep track of the last number used some how.
If the template is used by lots of people, you could have a text file in the same folder that keeps track. If it's only used by you, maybe you could store that number in your windows registry. You may want to look at how J.E. McGimpsey does it: http://mcgimpsey.com/excel/udfs/sequentialnums.html He has samples of both. Neville wrote: I have a "template" Excel workbook that, whenever I save it, it must be saved with a unique and sequential file name. How can I achieve this by means of macros or is there any other way of automating this function? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double-clicking .xls file opens Excel but doesn't open the file | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) |