Hi All,
Hoping to find some help with a problem I've been having. My work just upgraded to office 2013 and a few macros I created are not working anymore.
I have a macro that opens a word document and populates it with information from the excel workbook. I have it so that the word document opens as read-only. Part of the code looks like this:
Set wdDoc = wdApp.Documents.Open("U:\Data\Letterhead.docx", ReadOnly:=True)
However, I get the run-time error '6124': You are not allowed to edit this selection because it is protected.
If I change the code so that it doesn't open as read only, then it will work just fine. But I want to make sure the word document is kept as a read only file as it is a template. I don't want someone to accidentally save over the master template.
The macro/code worked how i wanted it to in prior versions of excel, but wont work in excel 2013. Any ideas on why that is?
Thanks...
Bookmarks