Can one write a macro to quietly close Word, with no user intervention?

rs

Re: Close Word with macro? by Charles

Charles
Mon May 22 09:28:29 CDT 2006

Yes.
What is it you are trying to accomplish? Version(s) of Word?
You may want to post this in the vba.beginners group.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"tcebob" <handle @ gwi.net> wrote in message
news:uayUppafGHA.5104@TK2MSFTNGP04.phx.gbl...
> Can one write a macro to quietly close Word, with no user intervention?
>
> rs
>
>



Re: Close Word with macro? by tcebob

tcebob
Mon May 22 10:32:25 CDT 2006

Charles,

That's a good news--bad news type of response. I like "yes" but only speak a few words of
vba. I will open the .beginners group and see how the wind blows.

The problem relates to a recent post of mine, "Word not closing right under Scheduler."
Scheduler opens a specific file, time.doc, and an hour later attempts to close it. This
creates an error condition and the Notify Microsoft window appears and has to be dismissed
manually. Don't know what would happen if I left the computer unattended until the next
Event time, 4 hours later. So, asking Scheduler to do more than simply closing Word is not
possible.

But, if I had the subject macro loaded and ran it upon startup of Word, I'm betting that
there is a timer reactor somewhere in vba that would delay the execution for, say, 2
hours.

Thanks,

rs


"Charles Kenyon" <wordfaq@nospam.addbalance.com> wrote in message
news:uskPAwafGHA.4892@TK2MSFTNGP02.phx.gbl...
: Yes.
: What is it you are trying to accomplish? Version(s) of Word?
: You may want to post this in the vba.beginners group.
: --
: Charles Kenyon
:
: Word New User FAQ & Web Directory: http://addbalance.com/word
:
: Intermediate User's Guide to Microsoft Word (supplemented version of
: Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
:
: See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
:
: My criminal defense site: http://addbalance.com
: --------- --------- --------- --------- --------- ---------
: This message is posted to a newsgroup. Please post replies
: and questions to the newsgroup so that others can learn
: from my ignorance and your wisdom.
:
:
: "tcebob" <handle @ gwi.net> wrote in message
: news:uayUppafGHA.5104@TK2MSFTNGP04.phx.gbl...
: > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:



Re: Close Word with macro? by tcebob

tcebob
Mon May 22 11:58:13 CDT 2006

Holy crabapples, it works! Here's the script (cribbed shamelessly from Help):

Sub ExitTime()
'
'Wait for 1 hour then exit word.
'
Dim PauseTime, Start
PauseTime = 3600 ' Set duration.
Start = Timer ' Set start time.
Do While Timer < Start + PauseTime
DoEvents ' Yield to other processes.
Loop
Application.Quit SaveChanges:=wdDoNotSaveChanges
End
End Sub

Thanks again,

rs


"Charles Kenyon" <wordfaq@nospam.addbalance.com> wrote in message
news:uskPAwafGHA.4892@TK2MSFTNGP02.phx.gbl...
: Yes.
: What is it you are trying to accomplish? Version(s) of Word?
: You may want to post this in the vba.beginners group.
: --
: Charles Kenyon
:
: Word New User FAQ & Web Directory: http://addbalance.com/word
:
: Intermediate User's Guide to Microsoft Word (supplemented version of
: Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
:
: See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
:
: My criminal defense site: http://addbalance.com
: --------- --------- --------- --------- --------- ---------
: This message is posted to a newsgroup. Please post replies
: and questions to the newsgroup so that others can learn
: from my ignorance and your wisdom.
:
:
: "tcebob" <handle @ gwi.net> wrote in message
: news:uayUppafGHA.5104@TK2MSFTNGP04.phx.gbl...
: > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:



Re: Close Word with macro? by Charles

Charles
Mon May 22 17:09:23 CDT 2006

Think about your habits (and those of your users) before you implement this!
What other documents are likely to be open? Will changes to those be a good
thing to save, or not? Do you really want to abandon changes to the document
you have been working on?
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"tcebob" <handle @ gwi.net> wrote in message
news:ee01EFcfGHA.1276@TK2MSFTNGP03.phx.gbl...
> Holy crabapples, it works! Here's the script (cribbed shamelessly from
> Help):
>
> Sub ExitTime()
> '
> 'Wait for 1 hour then exit word.
> '
> Dim PauseTime, Start
> PauseTime = 3600 ' Set duration.
> Start = Timer ' Set start time.
> Do While Timer < Start + PauseTime
> DoEvents ' Yield to other processes.
> Loop
> Application.Quit SaveChanges:=wdDoNotSaveChanges
> End
> End Sub
>
> Thanks again,
>
> rs
>
>
> "Charles Kenyon" <wordfaq@nospam.addbalance.com> wrote in message
> news:uskPAwafGHA.4892@TK2MSFTNGP02.phx.gbl...
> : Yes.
> : What is it you are trying to accomplish? Version(s) of Word?
> : You may want to post this in the vba.beginners group.
> : --
> : Charles Kenyon
> :
> : Word New User FAQ & Web Directory: http://addbalance.com/word
> :
> : Intermediate User's Guide to Microsoft Word (supplemented version of
> : Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> :
> : See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> :
> : My criminal defense site: http://addbalance.com
> : --------- --------- --------- --------- --------- ---------
> : This message is posted to a newsgroup. Please post replies
> : and questions to the newsgroup so that others can learn
> : from my ignorance and your wisdom.
> :
> :
> : "tcebob" <handle @ gwi.net> wrote in message
> : news:uayUppafGHA.5104@TK2MSFTNGP04.phx.gbl...
> : > Can one write a macro to quietly close Word, with no user
> intervention?
> : >
> : > rs
> : >
> : >
> :
> :
>
>



Re: Close Word with macro? by tcebob

tcebob
Mon May 22 21:30:22 CDT 2006

Not a problem. This macro is activated at the shortcut command for this particular
document, or in the Scheduler. Normal Word operation is not affected. Oh, wait, I see your
point; suppose some other document is being edited. Theoretically the operator is supposed
to see the time log pop up, fill in a line and dismiss it. But, of course, operator could
be away drinking lunch or studying the ponies in the rest room. Ok, there must be a way to
activate a document in a completely new run of Word. Or close the Log without closing Word
if there are more documents open.

But. The damn thing still doesn't work, though it works when I test it. It still gags on
something and puts up an error screen.

Back to the drawing board.

rs


"Charles Kenyon" <wordfaq@nospam.addbalance.com> wrote in message
news:e7KZixefGHA.356@TK2MSFTNGP02.phx.gbl...
: Think about your habits (and those of your users) before you implement this!
: What other documents are likely to be open? Will changes to those be a good
: thing to save, or not? Do you really want to abandon changes to the document
: you have been working on?
: --
: Charles Kenyon
:
: Word New User FAQ & Web Directory: http://addbalance.com/word
:
: Intermediate User's Guide to Microsoft Word (supplemented version of
: Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
:
: See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
:
: My criminal defense site: http://addbalance.com
: --------- --------- --------- --------- --------- ---------
: This message is posted to a newsgroup. Please post replies
: and questions to the newsgroup so that others can learn
: from my ignorance and your wisdom.
:
:
: "tcebob" <handle @ gwi.net> wrote in message
: news:ee01EFcfGHA.1276@TK2MSFTNGP03.phx.gbl...
: > Holy crabapples, it works! Here's the script (cribbed shamelessly from
: > Help):
: >
: > Sub ExitTime()
: > '
: > 'Wait for 1 hour then exit word.
: > '
: > Dim PauseTime, Start
: > PauseTime = 3600 ' Set duration.
: > Start = Timer ' Set start time.
: > Do While Timer < Start + PauseTime
: > DoEvents ' Yield to other processes.
: > Loop
: > Application.Quit SaveChanges:=wdDoNotSaveChanges
: > End
: > End Sub
: >
: > Thanks again,
: >
: > rs
: >
: >
: > "Charles Kenyon" <wordfaq@nospam.addbalance.com> wrote in message
: > news:uskPAwafGHA.4892@TK2MSFTNGP02.phx.gbl...
: > : Yes.
: > : What is it you are trying to accomplish? Version(s) of Word?
: > : You may want to post this in the vba.beginners group.
: > : --
: > : Charles Kenyon
: > :
: > : Word New User FAQ & Web Directory: http://addbalance.com/word
: > :
: > : Intermediate User's Guide to Microsoft Word (supplemented version of
: > : Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
: > :
: > : See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
: > :
: > : My criminal defense site: http://addbalance.com
: > : --------- --------- --------- --------- --------- ---------
: > : This message is posted to a newsgroup. Please post replies
: > : and questions to the newsgroup so that others can learn
: > : from my ignorance and your wisdom.
: > :
: > :
: > : "tcebob" <handle @ gwi.net> wrote in message
: > : news:uayUppafGHA.5104@TK2MSFTNGP04.phx.gbl...
: > : > Can one write a macro to quietly close Word, with no user
: > intervention?
: > : >
: > : > rs
: > : >
: > : >
: > :
: > :
: >
: >
:
: