Thread: =today()
View Single Post
  #5   Report Post  
Ron de Bruin
 
Posts: n/a
Default

How do you mail it
FileSend To or with a macro

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
More specificaly only when I mail it.

Kevin

"Ron de Bruin" wrote:

Hi

You must use code to do this or enter the date with a short cut

Ctrl ;

Or with code

Sub test()
ActiveCell.Value = Format(Date, "dd-mmm-yyyy")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kanaski79" wrote in message ...
Ok I have another question.

With the =today() function is there a way to automaticaly make the date a
value so It will not change again, say once you mail the file, or when you
post it to web folder or something?

Thanks guys.

Kevin