save as & copy worksheet code query

[fry]

Greetings everyone...

Can anyone help with a couple of queries I have...

I have a purchase order that is saved when completed using the following code 'Application.ActiveWorkbook.Save' but I'd like it at the same time to save another copy of the workbook as a backup. Is this possible?

Also on the same worksheet ("new purchase order") my code copies it to a new purchase order and gives it a consecutive order number. It then clears the "new purchase order" sheet to start again. My query is this...

Instead of clearing the "new purchase order" sheet, is it possible to delete the "new purchase order" sheet that was just used and then simply create a new "new purchase order" sheet by copying it from a "template" sheet I have created??

Sorry, a bit long winded but I'm getting very confused!! Incidentally can anyone recommend a good book for excel programming for the complete novice??

Thanks in advance

 

[MonkeyDeath]

Also on the same worksheet ("new purchase order") my code copies it to a new purchase order and gives it a consecutive order number. It then clears the "new purchase order" sheet to start again. My query is this...

sorry to hyjack but how did you do this, this is what i want to do,

 

[fry]

Hi Monkey

I'll send you the code if you want to use bits or pick it apart.

Whats your email address ??

 

[MonkeyDeath]

fry cheers ive sent you a PM

 

[fry]

Hi Monkey

I've emailed the code to you.

Anyone any ideas on the above????