Re: How can I programmatically relink OLE's in a Word document?

Oli was telling us:
Oli nous racontait que :

You are right, Jean-Guy. As I explained in my earlier replies, I
inserted all the objects by "Insert>Object>Microsoft Excel
Work***." I had to insert objects this way, because it was much
easier to copy the links and the formulas, down. I still need to
change the data sources in each embedded excel ***, though. I
edited your code as in the following. I know that it doesn't work
(it gives an error message of "Object doesn't support this property
or method"). However, it will give you an idea of what I am trying
to accomplish. Is it possible to change the data sources of the
Embedded Excel Sheets in the Word Document? Thanks in advance for
your help!!


As I wrote before you cannot link an embedded object to an external source.
The object is either linked or embedded, it cannot be both.
So if you want to "link" your embedded objects, you will have to remove
them, and then paste the Excel date as links (Edit > Paste Special).

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@xxxxxxxxxxxxxxxxxxxxxxx
Word MVP site: http://www.word.mvps.org


.