Notification on change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

D A N - 24 Apr 2007 14:26 GMT

Hi
How would I use VBA to recongnise that a change has been made in a word
document ?
'm trying to send myself an e-mail after one of my colleagues makes a
change, I have the code to send the mail but as this isn't excel with defined
areas and If formulas I can't figure out, how it would spot an update ?
Orignally i placed the code in "before_close & then in before_save" but a
large number of people view the document but have no comments/changes, so
this isn't practical.

Any ideas ??
Dan

Reply to this Message

Bear - 24 Apr 2007 23:30 GMT

Dan:

I'm just daydreaming here. How about storing the Save Date in a document
variable when the document is opened, then comparing the stored date against
the current Save Date when the document is closed? That would tell you
whether or not the user had saved the document during his session. But not
whether it was saved due to a change, or just saved for fun.

Bear

Signature

Windows XP, Word 2000

> Hi
> How would I use VBA to recongnise that a change has been made in a word
[quoted text clipped - 8 lines]
> Any ideas ??
> Dan

Reply to this Message

D A N - 25 Apr 2007 10:08 GMT

Cheers for the reply
i hadn't thought of that, i suppose its a bit like using "before close" in
that its a catch all scenario, although it's definitely "tighter"/better than
what i was doing before.

Cheers
Dan

> Dan:
>
[quoted text clipped - 18 lines]
> > Any ideas ??
> > Dan

Reply to this Message