B
Brutus
I am not sure if I post this question in the right
section, but this comes as close to my 'problem' as
possible.
I want to use information from an Excel sheet as
information in a Word document, but (and that's the
problem) I want to use relative links. To clarify: I have
a word document WORD.DOC and an Excel document EXCEL.XLS.
I copy cell A1 from EXCEL.XLS and PASTE AS LINK,
UNFORMATTED TEXT in WORD.DOC and it shows the dynamic
content of cell A1. Now, when I press SHIFT-F9 I see the
path to which the link refers. This is C:\MY
DOCUMENTS\EXCEL.XLS. What I want is that the link refers
to EXCEL.XLS (without pathinformation), so that when I
move both documents to a server or whatever other
location, the links still work without me having to alter
all the 'hardcoded' links.
Looking forward to your responses....
section, but this comes as close to my 'problem' as
possible.
I want to use information from an Excel sheet as
information in a Word document, but (and that's the
problem) I want to use relative links. To clarify: I have
a word document WORD.DOC and an Excel document EXCEL.XLS.
I copy cell A1 from EXCEL.XLS and PASTE AS LINK,
UNFORMATTED TEXT in WORD.DOC and it shows the dynamic
content of cell A1. Now, when I press SHIFT-F9 I see the
path to which the link refers. This is C:\MY
DOCUMENTS\EXCEL.XLS. What I want is that the link refers
to EXCEL.XLS (without pathinformation), so that when I
move both documents to a server or whatever other
location, the links still work without me having to alter
all the 'hardcoded' links.
Looking forward to your responses....