I want to be able to open an embedded word doc without using "ActiveDocument" as seen here:
Set wordObject = Worksheets(1).OLEObjects("TemplateDoc")
wordObject.Verb (xlVerbOpen)
Set wordDocTemp = ActiveDocument
This opens the word doc, then sets the wordDocTemp to that word doc, as its now active. I am unable to use wordObject as a word doc.
I've tried:
Set wordObject = Worksheets(1).OLEObjects("TemplateDoc").Verb (xlVerbOpen)
But this always returns run-time error 424 "Object Required"
Using "ActiveDocument" occasionally causes an error, which is why i need a workaround.