[MikeJacobs]

Office 2000 did not run fast enough back then, so I wrote VBA to better
manage exchanges from Excel to Word. Now that things are faster, I'm trying
to do the same thing with Linking and/or Embedding.

I have two template files, Word and Excel. Excel has 25 worksheets with
hundreds of calcs. I need the results in Excel, which are both values in
cells and "pictures" of formatted tables to be presented in Word.

Sounds easy, right? Linking seems to be made for this. Not so - the links
are not stable, apparently, with files of this complexity.

For example, I create my "templates" which are linked in the usual ways
(text, unformatted text, pictures, etc.). When I change the source using the
"PREPARE - EDIT LINKS" dialog, strange things happen. Some links remain
associated with the original source file while showing the new source file!
Some are just blown out! Some even work. I therefore have no confidence in
the files.

It's also a nightmare to manage that many links when I have external links I
do NOT want changed, and OLE links within the doc itself.

Embedding isn't working out either, since I need every Excel object in Word
to be the SAME object - a change in one filters through to all. Embedding a
worksheet simply seems to create a new copy of that worksheet. Each is
different.

So, am I back to writing code to do this? Am I missing something or perhaps
somebody knows of an Add-In for sale?