OLE data from Word tables to embedded Excel chart

[Tony Pluta]

I have a Word document with few tables. Some data from those
tables has to be used in embedded Excel chart. If I will
copy and paste/link the data into the excel data sheet all
works fine. But after closing the document and reopening
again the links are lost. The fields in excell are such as
follows

=Word.Document.8|'C:\test.doc'!'!OLE_LINK10

Is it possible to do what I am trying to do ?? If yes how

Thanks for any suggestions

Regards

Ton

 

[Word Heretic]

G'day "Tony Pluta" <[email protected]>,

I usually use bookmarks to nominate the range and link to that
instead.


Steve Hudson
Word Heretic Sydney Australia
Tricky stuff with Word or words

Email: Steve at wordheretic.com


Tony Pluta was spinning this yarn:

I have a Word document with few tables. Some data from those
tables has to be used in embedded Excel chart. If I will
copy and paste/link the data into the excel data sheet all
works fine. But after closing the document and reopening
again the links are lost. The fields in excell are such as
follows:

=Word.Document.8|'C:\test.doc'!'!OLE_LINK10'

Is it possible to do what I am trying to do ?? If yes how ?

Thanks for any suggestions.

Regards,

Tony

Steve Hudson

Word Heretic, Sydney, Australia

wordheretic.com

If answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.

 

[Tony Pluta]

I have found the working solution. It required to create Excel file which store the data. All is working now.

Regards,

Tony