Hi folks.
Another question following on from a previous issue that was resolved but without a practical implementation...

Can I embed WORD TEMPLATE into an excel sheet then open it as a normal template (ie., able to make changes).

Everything i have tried so far opens the template file and allows changes but then saves over the original embedded file.

What I would like is the keep the embedded file as a master, un-changeable document.

T_OLE_OB = "5"   'Temporary whilst testing


Set oleObject = ActiveWorkbook.Sheets("Template").OLEObjects(T_OLE_OB)  'How to open as template file and not just edit embedded item and thus overwrite on save??
oleObject.Verb Verb:=xlPrimary


Set WordDocument = oleObject.Object


Call Report_Data.KONSTANT_FIELDS 'Fills in the word documents bookmarks


WordDocument.SaveAs (S_PATH & E_REQ & " - " & E_DESC)  'Saves the file to dedicated point - this works but overrides the
Thanks