A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Time/Date stamps in Word



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2010, 02:22 AM posted to microsoft.public.word.tables
scottalanclymer
external usenet poster
 
Posts: 1
Default Time/Date stamps in Word


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
Ads
  #2  
Old February 7th, 2010, 08:01 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Time/Date stamps in Word

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



  #3  
Old February 7th, 2010, 04:42 PM posted to microsoft.public.word.tables
scottalanclymer[_3_]
external usenet poster
 
Posts: 1
Default Time/Date stamps in Word


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 -





--
scottalanclymer
  #4  
Old February 7th, 2010, 08: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 -



  #5  
Old February 8th, 2010, 03:17 AM posted to microsoft.public.word.tables
scottalanclymer[_4_]
external usenet poster
 
Posts: 1
Default Time/Date stamps in Word


'Greg Maxey[_2_ Wrote:
;456399']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")

ok, that's a little obscure for me. I know my way around Excel, but
Word is a different animal. Is that some kind of programming language?
Cause it's just jibberish to me. Let me put a section of my excel file
here.

http://home.comcast.net/~scottalancl...ent.times.xlsx

It's only 40K. It shows what I'm doing in Excel. I just want a simple
way to do the same thing in Word. Don't know how to apply programming
code in Word.





--
scottalanclymer
  #6  
Old February 8th, 2010, 10:07 AM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Time/Date stamps in Word

Greg has included vba code which when run will insert the time plus one hour
at the cursor - see http://www.gmayor.com/installing_macro.htm
If you want it calculate the date in the document without using a macro,
then refer to the link I pointed you to earlier. The field construction
required to add times is on the last page of the document. Ensure that you
read the introduction before using it.

--

Graham Mayor - Word MVP

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



"scottalanclymer" wrote in message
...

'Greg Maxey[_2_ Wrote:
;456399']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")

ok, that's a little obscure for me. I know my way around Excel, but
Word is a different animal. Is that some kind of programming language?
Cause it's just jibberish to me. Let me put a section of my excel file
here.

http://home.comcast.net/~scottalancl...ent.times.xlsx

It's only 40K. It shows what I'm doing in Excel. I just want a simple
way to do the same thing in Word. Don't know how to apply programming
code in Word.





--
scottalanclymer



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.