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

bkastner

New Member
Joined
May 16, 2015
Messages
7
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,924
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top