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