[geotso[_2_]]

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.
--
geotso
---- --- --- -- -- - -
please, remove hyphens to contact me
---- --- --- -- -- - -

[macropod[_2_]]

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/ind...owtopic=670027


--
Cheers
macropod
[Microsoft MVP - Word]


"geotso" wrote in message ...
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.
--
geotso
---- --- --- -- -- - -
please, remove hyphens to contact me
---- --- --- -- -- - -

[macropod[_2_]]

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/ind...owtopic=670027


--
Cheers
macropod
[Microsoft MVP - Word]


"geotso" wrote in message ...
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.
--
geotso
---- --- --- -- -- - -
please, remove hyphens to contact me
---- --- --- -- -- - -