Prev: How do I convert word to pdf?
Next: How do I remove attached envelopes?
From: geotso on 14 Apr 2010 09:36
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
---- --- --- -- -- - -

From: macropod on 14 Apr 2010 17:56
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


--
Cheers
macropod
[Microsoft MVP - Word]


"geotso" <ge-o-tso(a)hotmail.com> wrote in message news:0336478F-4D28-4D99-AD5A-69493BDF6D9A(a)microsoft.com...
>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
> ---- --- --- -- -- - -
>
 | 
Pages: 1
Prev: How do I convert word to pdf?
Next: How do I remove attached envelopes?