Field codes: Link field

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

Links information you copied from another application to the original source file using OLE. Microsoft Word inserts this field when you copy information from another application and use the Paste Special command (Edit menu) to paste it into a Word document.

Instructions

ClassName

The application type of the linked information. For example, for a Microsoft Excel chart, ClassName is "ExcelChart." 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 determined by the parameter.

\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.

Examples

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 }