document properties option

[Ivano]

Hi,
I have links to area's selected in an Excel worksheet and when I click on
Edit Links the path is very long. The link is in 2 parts - the path and then
the file name I want to shorten this and it has been suggested to create a
custom document properties to carry the full path information and then
replace the path in the LINK field with a DocProperty field.
How do I do this?

 

[Peter Jamieson]

In theory how you do it is
a. use File|Properties|Custom in the UI to create a Custom Document
Property - let's call it "myprop", with the path name of the worksheet you
want to link to.
b. where you have a LINK field such as

{ LINK Excel.Sheet.8 "c:\\mypath\\mywb.xls" "sheet!rangename" \a \p }

you replace the path name by a field { DOCPROPERTY myprop }

e.g.

{ LINK Excel.Sheet.8 "{ DOCPROPERTY myprop }" "sheet!rangename" \a \p }

However, in my experience the next time you save/open your document and/or
update the LINK field, the DOCPROPERTY field is completely replaced by its
current value, so the technique does not really help (it did not used to
work that way).

If you want to try it, all the {} need to be the special field braces that
you can insert using ctrl-F9. You may need to double up all backslashes,
e.g. c:\\mypath\\mywb.xls. Make sure you do not accidentally insert any
spaces that should not be in the path name.

Peter Jamieson

 

[Ivano]

Thanks Peter,
My Word document has a pasted link that came from an Excel Worksheet
worksheet range. I selected a range in Excel went to Word clicked on paste
special, paste link and picked the first option Excel Worksheet Object. Now
when I go to the body of the Word document I see the pated excel sheet. So
it's the link path to the object that I need to change (there's about 30 of
them).

I could not understand how what you told me to do will change the path to
the Excel Worksheet object. Is there somewhere I can go withing the Word
document that will alllow me to edit the actual text as you suggested "> you
replace the path name by a field { DOCPROPERTY myprop }"?
sorry if I misunderstood you but please explain.

Thanks,

 

[Peter Jamieson]

When you link, Word inserts a { LINK } field. So if you use Alt-F9 to show
the underlying fields, you should see the { LINK }, and what I said may
become more clear.

It's possible that there are ways of inserting links that do not show up
when you use Alt-F9, but try that first.

Peter Jamieson