Capturing Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Fish - 26 Sep 2006 13:39 GMT

I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.

Reply to this Message

Jaleel - 26 Sep 2006 13:58 GMT

Hi,

Why do you need a macro for this if Excel has a formula like this? In Cell
D2, put: =TODAY()

> I have tried writing a macro that would let me capture the date from my
> computer and place it in cell D2. The captured day will be moved intact at
[quoted text clipped - 3 lines]
>
> Thanks for the help in advance.

Reply to this Message

Alan - 26 Sep 2006 13:59 GMT

Sub Macro1()
Sheet1.Range("D2") = Date
End Sub
Regards,
Alan.

>I have tried writing a macro that would let me capture the date from my
> computer and place it in cell D2. The captured day will be moved intact
[quoted text clipped - 4 lines]
>
> Thanks for the help in advance.

Reply to this Message

SteveW - 26 Sep 2006 14:01 GMT

=today() puts the current date as taken from your PC !
=now() is the same plus the time

Steve

> I have tried writing a macro that would let me capture the date from my
> computer and place it in cell D2. The captured day will be moved intact
[quoted text clipped - 4 lines]
>
> Thanks for the help in advance.

Reply to this Message

MartinW - 27 Sep 2006 13:40 GMT

The TODAY() and NOW() functions are volatile and will constantly
update. If you want the date to stick just hit ctrl+; for the date only.
If you want date and time hit ctrl+; space ctrl+shift+:

If you need it automatic then have a look here

http://www.mcgimpsey.com/excel/timestamp.html

HTH
Martin

Reply to this Message