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
Bookmarks