Field codes: Link field

The Link field links information from another application to your Word document by using OLE. Microsoft Word inserts this field when you copy information from another application and paste it into a Word document by using the Paste Special command (Home tab, Clipboard group, Paste command arrow button).

Security Note: Because field codes can be visible to anyone reading your document, be sure that the information you place in field codes is not information that you want kept private.

Syntax

When you view the FieldName field in your document, the syntax looks like this:

{ LINK ClassName "FileName" [PlaceReference ] [Switches ] }

Note:  A field code tells the field what to show. Field results are what’s shown in the document after having evaluated the field code. To toggle between viewing the field code and the field code results, press Alt+F9.

Instructions

ClassName

The application type of the linked information. For example, for a Microsoft Excel chart, ClassName is "Excel.Chart.8." Word determines this information from the source application.

"FileName"

The name and location of the source file. If the location includes a long file name with spaces, enclose it in quotation marks. Replace single backslashes with double backslashes to specify the path, for example:

"C:\\MSOffice\\Excel\\Rfp\\Budget.xls"

PlaceReference

Identifies the portion of the source file that's being linked. If the source file is a Microsoft Excel workbook, the reference can be a cell reference or a named range. If the source file is a Word document, the reference is a bookmark.

Switches

\a

Updates the LINK field automatically; delete this switch to use manual updating.

\b

Inserts the linked object as a bitmap.

\d

Graphic data isn't stored with the document, thus reducing the file size.

\f

Causes the linked object to update its formatting in a particular way, according to one of the following parameters.

This value

Specifies

0

Maintain the formatting of the source file

1

Not supported

2

Match the formatting of the destination document

3

Not supported

4

Maintain the formatting of the source file, if the source file is an Excel workbook

5

Match the formatting of the destination document, if the source file is an Excel workbook

\h

Inserts the linked object as HTML format text.

\p

Inserts the linked object as a picture.

\r

Inserts the linked object in rich-text format (RTF).

\t

Inserts the linked object in text-only format.

\u

Inserts the linked object as Unicode text.

Example

The following example inserts a range of cells from a Microsoft Excel worksheet. The \a switch ensures that the information is updated in Word whenever the worksheet is changed in Microsoft Excel:

{ LINK Excel.Sheet.8 "C:\\My Documents\\Profits.xls" "Sheet1!R1C1:R4C4" \a \p }

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×