How to open a Word doc in VBA (2)
Posted on 2014-11-20
In response to my original question of the same title, hnasr gave me the following code;
Dim objWord As Object, objDoc As Object
'Start Word and open a new document
Set objWord = CreateObject("Word.Application")
objWord.Visible = True
Set objDoc = objWord.Documents.Add
' existing doc
Dim objDoc2 As Object
Set objDoc2 = objWord.Documents.Add(ReportName)
It worked fine when applied to a standard document, but when I opened a document created in Mail Merge, it did not refresh the selected record.
Thanks in advance.