Maintain link from Word to Excel even when Excel file name changes

[bkastner]

I am working on a pricing worksheet and am trying to get the pricing table I create to show up in a MS word document. I can create a basic link, which works, but I need to account for file renaming.

Here is a quick summary.

I have 'Pricing.xml' and 'Word Template.doc'.

I know I can create an Excel table in 'Word Template.doc' by copying the cells from the 'Pricing.xml'.

My issue is that these are both template files. When I create an actual set of customer documents from them these files will be saved as another name:

'Customer Project.doc' and 'Customer Project.xml'.

The file names of the MS Word and MS Excel files will always match.

Does anyone know of a way to have the MS Excel link reference the MS Word file name for it's lookup so that my table can always be referenced?
Is there a better way to handle this type of linking?

I've been told there is a way to maintain the link if both files are in the same directory, however I may have multiple MS Word/MS Excel pairs in a single folder, so I need a way for the MS Word document to identify the correct MS Excel file to use.

Hopefully this makes sense, and hopefully this is the correct forum for this. I don't know if I should be posting in a MS Word forum, but I am hoping someone has done something similar here and may have suggestions.

Thanks
Bill