View Single Post
  #1   Report Post  
Timvdv
 
Posts: n/a
Default Relative path in LINK field ?

I use LINK fields in Word to get data from Excel.
In the LINK fields I have to specify the filename of the excel file as the
data source.
Unfortunately Word uses the full pathname to this file in the Field Code :

{ LINK Excel.Sheet.8 "c:\\User\\temp\\test\\Data.xls" "Sheet1!R2C2" \a \t }

For me this is a problem, I would like to mail both the Document and the
Excel file to other people, and I have no control over where they will save
it.

Is there a way to use relative paths in the LINK field instead of absolutes
paths ?
If I put both the .doc file and the .xls file in the same folder, can I make
this work somehow ?

Thank you,
Timvdv