Why are you so bound and determined to get an answer here when you've
already gotten two answers in another NG? If you persist, you'll only get
the same answers here, as this NG is read by pretty much the same people.
But just to prove that I can be helpful, here are some answers for you:
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
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")
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"scottalanclymer" wrote in
message ...
OK you're obviously the local forum cop. You realize you're
single-handedly
defeating the whole purpose of the forum which you patrol? This is all
here
for information. Education. Solving problems. You're doing the opposite.
You're creating a problem and ignoring the original question entirely. I
really feel sorry for the people in your life that have to put up with you
everyday. Your whole purpose is to find fault. Butt out if you can't
address
the thread. You keep wasting my time and I WILL unload on you. Go away.
"Suzanne S. Barnhill" wrote:
Yes, I see now that the header on that post does say ""scottalanclymer"
wrote in message
," but WordBanter (whatever
that
is), is obviously just a pipeline to the Microsoft newsgroups on Usenet,
and
it appears in the newsgroup I cited. Graham Mayor posted a reply there,
to
which you replied, and Greg Maxey posted a follow-up. Regardless of how
you
are posting, I am seeing all these postings on the Microsoft news server
via
NNTP.
Most of us who post in these newsgroups do read several of them, and we
don't distinguish the source of the posts, so your post in
microsoft.public.word.tables and the identical one here in
microsoft.public.word.newusers appeared to me to be duplicates (as in
fact
they were). Since you are posting here through the Microsoft Communities
Discussion Groups, I suggest that you look in the list of discussion
groups
for the one labeled "tables," where you will find your duplicate post.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"scottalanclymer" wrote in
message ...
I posted it on WordBanter. Never heard of
"microsoft.public.word.tables".
Don't know what it is. Don't want to know what it is. I'm not here to
understand forums. I'm here to try and get a simple answer. If you're
more
into interrogating new users, sorry. I'm not here for that. If you have
any
help, it would be appreciated.
"Suzanne S. Barnhill" wrote:
Are you not the person who posted this message in
microsoft.public.word.tables, under the screen name "scottalanclymer,"
at
8:22 PM CST yesterday?
"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?"
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"scottalanclymer" wrote in
message ...
This is the first time I've ever posted on this site. I'm just
looking
for
help on the question. There's 1 reply, it's you telling me I asked
twice.
I
did not. Is there help to be found here, or is it just hassle?
"Suzanne S. Barnhill" wrote:
Please see replies to your previous duplicate question.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"scottalanclymer" wrote
in
message ...
Have been using Word to edit my webpage for a couple years now.
Have
5
timezones I want to display and automatically update every time I
open
the
file to show when the page was last updated. 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. It is based on the
premise
that 1
hour = 0.041666666666666666666666666666667 of a day. The math is
very
simple.
It's just 1/24 to extract the decimal value of 1 hour. 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 want to flush the whole Excel table method, and be
able
to
write the code in Word, 5 lines, utilizing the time/date
function,
with
offsets for the hours I need. The goal is to have all 5 lines
update
with
no
work on my part each time I open the file for editing.
My question in it's simplest form is:
How can I insert the date+time in a Word document, but offset by
1
hour?
.
.
.