EXCEL 2013 - opening read only files and editing them

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...

nevermind..

i figured out why it was happening and the fix...

word 2013 will open read-only files in reading mode.
I just added another line to the code:

wdApp.ActiveWindow.View.readinglayout = False