Save file name as a timestamp.

[NickEvans]

I would like to create an excel worksheet that people could use and then
click a macro button to save as a timestamp and send through e mail so
that when the file is sent to a common in box, it has a unique filename
based on the time and date that it was filled out.

 

[Ron de Bruin]

I use that in my mail examples
http://www.rondebruin.nl/sendmail.htm

 

[Bob Phillips]

Nick,

To save as a date named file use

ActiveWorkbook.SaveAs Filename:= Format(myDate,"yyyy mm dd")

where myDate holds your date.

To send by email, see Ron de Bruin 's site, www.rondebruin.nl/sendemail.htm

 

[Ron de Bruin]

To send by email, see Ron de Bruin 's site, www.rondebruin.nl/sendemail.htm

Typo , must be

http://www.rondebruin.nl/sendmail.htm



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

Nick,

To save as a date named file use

ActiveWorkbook.SaveAs Filename:= Format(myDate,"yyyy mm dd")

where myDate holds your date.

To send by email, see Ron de Bruin 's site, www.rondebruin.nl/sendemail.htm

 

[Bob Phillips]

oops, sorry Ron!

--

HTH

Bob Phillips

To send by email, see Ron de Bruin 's site,

www.rondebruin.nl/sendemail.htm

Typo , must be

http://www.rondebruin.nl/sendmail.htm