Call command using MS Word

[JONESISGOOD]

Is there any way to open Microsoft Word one time within Access and then open multiple files in that one instance of Word? Right now we use Call Shell("Microsoft Word", File1) and then Call Shell("Microsoft Word", File2). This opens Word up 2 times, one for each file we want to open. We would like Word to open on the first instance of a call to Word, and then use the existing Application to open File2 ?

 

[RobertT687]

Yes. Just finished a project doing just that.
1) Establish connection to the Word object:
Dim wrdApp As Object
Set wrdApp = CreateObject("Word.Application&quot
2) In some sort of loop, open the selected Word Documents
Dim myDoc As Object
Set myDoc = wrdApp.Documents.Open(YourFileNamesHere)
do what ever you have to do
wrdApp.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges
Set myDoc = Nothing
3) Finish with the WOrd object
wrdApp.Quit
Set wrdApp = Nothing

Be sure to change the SaveChanges parameter if you mean to save or discard changes. My app required the changes to be discarded.