Help with a routine that saves a workbook

[HeyThere]

I want to know how it is possible to have "an automated routine that will archive the workbook and will create a new workbook ready for entering the new data".

So basically this code, (if that's the best method) "Save as" and enter a random name, perhaps a date as the file name. and open an original blank workbook up again.

All ideas welcome, thankyou!

 

[bertie]

Hi,

You have answered your own query in the second sentence. Use the original workbook as a template.

Open up the Original Workbook
Click File => Save As and name the file
Enter Data

Bertie

 

[Norie]

Sounds like you want to create a template, that would probably be the easiest way to do something like this.

PS Are you sure you want to use a random name for the workbook you are saving?

How would you identify it later?