[Drew]

This has to be the most frustrating thing I've seen. The application is
almost there... It seems like this would be the logical next step.

I started by created an .xls and linking about 20 fields in my .doc to the
..xls. Everything was working great until I needed to change the file names
from "template" to "[clientname]".

I realized that if I have the template.doc open with all the links
auto-updating, and I SAVE AS the .xls, most of the links follow the new .xls
file name. Then I can Save As the .doc and ta-da. But it wasn't perfect and
sometimes the links did not follow the filename.

So then I got the idea of embedding a worksheet as an object into the .doc
and link to it instead of linking to a source file. But the Link needs to
refer to the path of the document and then to the objectID and r/c
referrence. If I Save As the .doc, none of the links follow the new
filename. They all still link to the full path of "c://mydoc//template.doc"
_12345Sheet!rXcY.

One, is there a better way to accomplish what it is I'm trying to do?

Two, is there a way to set up a link so that the path is the current
document name regardless of the name of the current document?

Thanks a million in advance.

- Drew