C
capricorn33
I have a word template with an embedded excel sheet in it. I use a field to
display the text from a cell in the sheet in another place in the word
document, using the {LINK Excel.Sheet.8 "\\\..path..\\Template.dot"
_1135171229!Sheet1!CELLNAME \a \t \* CHARFORMAT { }}
Works fine - until I create a new document from the template and the
identifier _1135171229 changes its value.
I know how to change the identifier through VBA (as I already do the similar
thing with the path and document name, which change too.)
My problem is this;
I can't find any simple way to get that new identifier from the newly
created document! Is there any fast and simple way to do that?
display the text from a cell in the sheet in another place in the word
document, using the {LINK Excel.Sheet.8 "\\\..path..\\Template.dot"
_1135171229!Sheet1!CELLNAME \a \t \* CHARFORMAT { }}
Works fine - until I create a new document from the template and the
identifier _1135171229 changes its value.
I know how to change the identifier through VBA (as I already do the similar
thing with the path and document name, which change too.)
My problem is this;
I can't find any simple way to get that new identifier from the newly
created document! Is there any fast and simple way to do that?