View Single Post
  #4  
Old February 7th, 2010, 09:44 PM posted to microsoft.public.word.tables
Greg Maxey[_2_]
external usenet poster
 
Posts: 649
Default Time/Date stamps in Word

Selection.InsertAfter "The time: " & Format(Time, "h:mm") & _
vbCr & "The time an hour ago: " & _
Format(DateAdd("h", -1, Time), "h:mm") & vbCr & _
"The time an hour from now: " & Format(DateAdd("h", 1, Time), "h:mm")



scottalanclymer wrote:
Let me simplify my question:
Is there a simple code to insert the current system time, but offset
by 1 hour, in a Word document?


Graham Mayor;456330 Wrote:
See http://www.gmayor.com/insert_a_date_...than_today.htm
and particularly the link there to
http://www.gmayor.com/downloads.htm#Third_party

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"scottalanclymer" wrote in
message
...-

Have been using Word to edit my webpage. Have 5 timezones I want to
automatically update the stamp every time I open the file. See it at
home comcast net ~scottalanclymer. I think the method I'm currently
using is considered a table. It's a snippit of a few columns and rows
from excel using the formulas I already had there in my daily
worksheet. But every time I open my page in Word to update it, I
have
to right click the table, hit O, hit E, the table updates the
formulas
from the current system time. Then I hit escape. It creates an IMAGE
of
the table. Then I have to adjust the width or heighth of the image to
make it look like it's close to being normal again. It's a pain. I'd
rather be able to write the code in Word, 5 lines, utilizing the
time/date function, with offsets for the hours I need, I already have
the math done on that, and have all 5 lines update with no work on my
part each time I open the file for editing. Any takers on this
challenge?




--
scottalanclymer -