hi,
it depends on the template. if you use an Auto_open ()
macro that sets the number you can record that number in a
text file or another workbook. Better a text file so that
that file does not need to be open like a workbook. Look
up WriteLine in msdn help