I have created the following code:

Sub Button25_Click()
'save workbook and email
ActiveWorkbook.SaveAs Filename:="C:\TGP.xls"
ActiveWorkbook.SendMail Recipients:="[email protected]"
End Sub
I would like to know how I can add two things to this code.

1. I would like the code to create a folder in my C: drive named BackupTGP.
2. I would like to have the filename be the current date and time.

Then reason I want to do this is so that I can continuosly save the time/date stamped file to that folder as a backup to the save in the 'My Doc' folder.