Closing Word using Automation

[richardb]

My Access database controls a Mail Merge Job in Word. After generating the
data, Access opens the Word document with these lines of code in a module:

Set objWord = GetObject("G:\Access Projects\MyWordDoc.doc", "Word.Document")
objWord.Application.Visible = True
objWord.RunAutoMacro wdAutoOpen

In the Word document the Sub AutoOpen Prints the mail merge job. My AutoOpen
code ends with ActiveDocument.Close wdDoNotSaveChanges. Unfortunately, all
this does is to close the document. What I want is to completely close out
Word and return my screen to Access where I left off. I have searched, but
can't figure out how to do this. Would appreciate assistance.

 

[Gina]

Try

Application.Quit SaveChanges:=False
maybe in AutoExit() - may not be done in the Close event ....

cheers,
Gina

 

[Jonathan West]

My Access database controls a Mail Merge Job in Word. After generating the
data, Access opens the Word document with these lines of code in a module:

Set objWord = GetObject("G:\Access Projects\MyWordDoc.doc",
"Word.Document")
objWord.Application.Visible = True
objWord.RunAutoMacro wdAutoOpen

In the Word document the Sub AutoOpen Prints the mail merge job. My
AutoOpen
code ends with ActiveDocument.Close wdDoNotSaveChanges. Unfortunately, all
this does is to close the document. What I want is to completely close out
Word and return my screen to Access where I left off. I have searched, but
can't figure out how to do this. Would appreciate assistance.

Take a look here


Control Word from Excel
http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm


The same principles apply to controlling Word from Access


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[richardb]

Hi Jonathan,

That was very helpful, but I still cannot restore Access as the Active
(i.e., visible [in case "Active" is the wrong term]) application after I
close the word document. Access remains minimized. Advice appreciated...thank
you...

 

[Jonathan West]

Hi Richard

Since you are working in Access and trying to change the activated status of
the Access application, you will have a better chance of getting an
authoritative answer from one of the Access programming newsgroups.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Hi Jonathan,

That was very helpful, but I still cannot restore Access as the Active
(i.e., visible [in case "Active" is the wrong term]) application after I
close the word document. Access remains minimized. Advice
appreciated...thank
you...

Take a look here


Control Word from Excel
http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm


The same principles apply to controlling Word from Access


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

 

[Tony Jollans]

When Word has finished running its stuff - you can close Word from Access
with

objWord.Quit
Set objWord = Nothing