' Set to True if you want to see the Word Doc flash past during construction Set objWord = CreateObject("Word.Application") SMName = Sheets("Release LettersAR").Cells(r, 2).ValueĬonst WTempName = "MailMergeMainDocumentAR.docx" 'This is the Word Templates name, Change as req'dĬDir = ActiveWorkbook.Path + "\" 'Change if appropriate LastRow = Sheets("Release LettersAR").Range("B" & Rows.Count).End(xlUp).Row I have been asking around everywhere and no one seems to know as no one has responded!Īny help would be greatly appreciated Private Sub cmdGenerateAR_Click() If I try to open it or anything else, I can only open as a read only copy.
If I try to delete one I get a pop-up stating that the action can't be completed because the document is open in "Word (Desktop)".
Once the docs are created, they are also locked for editing. I am using Excel to run a mail merge, and everything works great "EXCEPT".
0 kommentar(er)
