Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Save Babysitter?

3 views
Skip to first unread message

Fester Bestertester

unread,
Jan 13, 2008, 1:20:00 PM1/13/08
to
Greetings,

I've done some googling on this issue, but I haven't seen a lot of
solutions, so I'm wondering if there are any opinions or recommendations
in this group.

We're using Word 2K3, sp3.

I have a user who occasionally opens an existing document, and then
spends an hour or more editing it while multitasking, without ever
hitting the Save button. Then, in a distracted or multitasking moment,
she'll close the document, or exit Word, and unintentionally click "No"
on the "Save" dialog. Then, she'll come running to me wanting to know
how to recover all the stuff she just spent hours writing.

I've explained to her, on multiple occasions, that if you click "No" on
the "Save" dialog when closing or exiting, the application will obey
your command. But she's really not satisfied with that answer.

Did I mention that she's my boss?

So what solutions have people out there seen for this problem? Bear in
mind that I'm not referring to the Backup copy feature, which creates a
snapshot ".wbk" file of what the document looked like the last time the
user hit the Save button. Nor am I talking about the
AutoSave/AutoRecover feature, which creates a temporary file so that
work can be recovered in case there is a power failure or some other
kind of crash.

And I'm not looking to create a lot of server overhead by creating
dozens and dozens of archive files, so I’m not really looking for an
archive feature either.

I guess what I'm looking for is a "Save babysitter": a VBA solution that
will actually save the existing document *as* the existing document, at
some regular interval (or at least prompt the user to hit the Save
button at some regular interval if she has not done so).

Has anyone seen a VBA solution for such a problem?

BTW, did I mention that the user in question is my boss?

Suggestions and link referrals appreciated.

PS I tested Graham Mayor's SaveReminder in Word 2K3 but it caused Word
to crash. Either the code hasn't been updated for Word 2K3 or the
instructions in the Readme need to be updated.

Fester Bestertester

unread,
Jan 13, 2008, 4:24:09 PM1/13/08
to
Turns out MS produced a very nice save reminder project that's included
with a set of macros they developed way back for Word 2000:

http://support.microsoft.com/kb/237356/en-us

The only thing you need to change for Word 2003 is set Macro Security to
allow access to Trust access to the Visual Basic project.

I've tested it a few times now and it works great!

0 new messages