Please help, I have a routine that opens a Word doc from Access, but now I want to open 2 documents at the same time. How do I set 2 variables so that I can activate one, then switch and activate the other?
Public Const WordDot As String = "c:\Test.dot"
Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application"
Documents.Open WordDot, , ReadOnly
ActiveDocument.Select
ActiveDocument.Close (wdDoNotSaveChanges)
objWord.Quit
Set objWord = Nothing
Public Const WordDot As String = "c:\Test.dot"
Dim objWord As Word.Application
Set objWord = CreateObject("Word.Application"
Documents.Open WordDot, , ReadOnly
ActiveDocument.Select
ActiveDocument.Close (wdDoNotSaveChanges)
objWord.Quit
Set objWord = Nothing