Link field - relative path

[geotso]

I copy a cell in Excel and then I paste it as link in Word. I get the
following link field:

{LINK Excel.Sheet.12 C:\\Users\\geotso\\Desktop\\Book1.xlsx Sheet1!R1C1 \a
\f 5 \h \* MERGEFORMAT }

How can I convert the absolute path to relative? I want to move the files in
another location without breaking the link.

 

[macropod]

Hi geotso,

You can't. For a macro-based workaround, though, see the code attached to the solution I've posted at:
http://lounge.windowssecrets.com/index.php?showtopic=670027