I have created the following code:


Code:
--------------------

Sub Button25_Click()
'save workbook and email
ActiveWorkbook.SaveAs Filename:="C:\TGP.xls"
ActiveWorkbook.SendMail "
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.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=466512