View Single Post
  #1   Report Post  
Posted to microsoft.public.word.oleinterop,microsoft.public.word.formatting.longdocs,microsoft.public.word.docmanagement
Jose Valdes Jose Valdes is offline
external usenet poster
 
Posts: 27
Default Using DOCPROPERTY in LINK field

I am writing a long manual in MS-Word 2003 that uses OLE links to MS-Excel
files. Here's an example of one of my links:

{ LINK Excel.Sheet.8 "{ DOCPROPERTY home_folder}RMS 2400\\Book
files\\Linked_files\\2400\\Section_2.doc\\RMS_2400 _Slip_Die.xls" "Body" \a
\f 0 \p }

In this example, please note that I use a custom document property,
"home_folder", to store the directory path to the Excel file,
"RMS_2400_Slip_Die.xls". The following example shows the link with the value
of the DOCPROPERTY:

{ LINK Excel.Sheet.8 "G:\\TRS_Engineering\\Operations manuals\\Work in
progress\\RMS 2400\\Book
files\\Linked_files\\2400\\Section_2.doc\\RMS_2400 _Slip_Die.xls" "Body" \a
\f 0 \p }

I thought I was pretty smart when I developed this plan, but Word has won
another round against me. ;-) Every time I update the previous link, Word
helpfully renames the directory path to the following:

{ LINK Excel.Sheet.8 "\\\\spencerroad1\\groups\\TRS_Engineering\\Operat ions
manuals\\Work in progress\\RMS 2400\\Book
files\\Linked_files\\2400\\Section_2.doc\\RMS_2400 _Slip_Die.xls" Body \a \f
0 \p }

The new directory path is correct and displays the Excel file as it should.
It does not, however, use the DOCPROPERTY. When it was time to move the word
file to another computer, I was hoping to change the DOCPROPERTY and
re-define all of these links. This plan has so far worked for the
INCLUDEPICTURE and INCLUDETEXT fields. Can I make it work with the LINK
field as well?