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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#4
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|