I have an Access macro which opens a new Word window, opening a pre-created .doc file. It then searches for key strings and replaces them.
This works fine as long as word isn't already open. If I have a seperate document open, the new document opens on top, appears active, but my modifications done in VBA are executed on the first document.

I am using this code to try and 'activate' the document I want, but to no avail:
Set wrdApp = CreateObject("Word.Application")
    wrdApp.Visible = True
    wrdApp.Activate
    Set wrdDoc = wrdApp.Documents.Open("" & GetDBPath() & "MyDocument.doc")
    wrdDoc.Activate
Thanks for your help.