[Manu]

Hi,
I created two documents in Office 2007. The first is an quote
calculator/generator in excel. The second prints out a pretty quote based on
the values in the excel file. I linked the different values in Word to the
cells in Excel via Paste Special..

Now I want to distribute these two documents as a set so that others can
create quotes and print out the results.

However, it seems that the shortcuts are all absolute and do not link to the
Excel sheet in the same directory. How do I enable these two documents to be
transported together in the same directory?

Thanks!

[macropod[_2_]]

Hi Manu,

See the macro attached to:
http://www.wopr.com/cgi-bin/w3t/show...?Number=670027

--
Cheers
macropod
[MVP - Microsoft Word]


"Manu" wrote in message ...
Hi,
I created two documents in Office 2007. The first is an quote
calculator/generator in excel. The second prints out a pretty quote based on
the values in the excel file. I linked the different values in Word to the
cells in Excel via Paste Special..

Now I want to distribute these two documents as a set so that others can
create quotes and print out the results.

However, it seems that the shortcuts are all absolute and do not link to the
Excel sheet in the same directory. How do I enable these two documents to be
transported together in the same directory?

Thanks!