T
tcebob
Can one write a macro to quietly close Word, with no user intervention?
rs
rs
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Charles Kenyon
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
--------- --------- --------- --------- --------- ---------
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.
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
--------- --------- --------- --------- --------- ---------
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.
T
tcebob
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:
T
tcebob
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > Can one write a macro to quietly close Word, with no user intervention?
: >
: > rs
: >
: >
:
:
C
Charles Kenyon
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
--------- --------- --------- --------- --------- ---------
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.
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
--------- --------- --------- --------- --------- ---------
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.
T
tcebob
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > 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
: >
: >
: > : > : 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
: > :
: > :
: > :
: > :
: > : --------- --------- --------- --------- --------- ---------
: > : 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.
: > :
: > :
: > : : > : > Can one write a macro to quietly close Word, with no user
: > intervention?
: > : >
: > : > rs
: > : >
: > : >
: > :
: > :
: >
: >
:
:
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
: 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
:
:
:
:
: --------- --------- --------- --------- --------- ---------
: 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.
:
:
: : > 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
: >
: >
: > : > : 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
: > :
: > :
: > :
: > :
: > : --------- --------- --------- --------- --------- ---------
: > : 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.
: > :
: > :
: > : : > : > Can one write a macro to quietly close Word, with no user
: > intervention?
: > : >
: > : > rs
: > : >
: > : >
: > :
: > :
: >
: >
:
: