td stamp

[BorisS]

I need VB code which will type "{Current Date}, "Current Time}", obviously
replacing the words here with the actual values at that time. If there is a
choice (I am thinking of Excel here), I would love to have Date in "Tue,
04-Jan-05" format and time in military format.

Thx for any help.

 

[JackD]

In VB use the now() function.
But there isn't much need for this. You can just press CTRL+; for date and
CRTL+: for the time.
Then format as you like.
You might also check out the format function. It can do this as well.

 

[John]

I need VB code which will type "{Current Date}, "Current Time}", obviously
replacing the words here with the actual values at that time. If there is a
choice (I am thinking of Excel here), I would love to have Date in "Tue,
04-Jan-05" format and time in military format.

Thx for any help.

Boris,
Despite what Mike Glen said about using this newsgroup, I already
answered you original post. Look there.

John
Project MVP