I have created a template for a sales information sheet. I would like it to
generate a new unique sequential number starting at 100001 every time that
the template is opened. when the file is closed I wold like it to be saved
as a .xls using the unique number plus customer name as the file name.

Can this be done?