LINK

Syntax:

LINK field-argument-1 field-argument-2 [ field-argument-3 ] [ switches ]

field-argument-1:field-argument

field-argument-2:field-argument

field-argument-3:field-argument

Description: For information copied from another application, this field links that information to its original source file using OLE. The application type of the link information is specified by field-argument-1. The name and location of the source file is specified by field-argument-2. field-argument-3 specifies the portion of the source file that's being linked.
example: : If the source file is a SpreadsheetML document, the reference might be to a cell reference or a named range. For a WordprocessingML document, it might be a bookmark.

Field Value: None.

Switches: Zero or more of the following field-specific-switches.

\a

Causes this field to be updated automatically.

\b

Inserts the linked object as a bitmap.

\d

Don’t store the graphic data with the document, thus reducing the file size.

\f field-argument

Causes the linked object to update its formatting in a particular way, according to the integral value of text in this switch's field-argument. The possible values are:

  • 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 a SpreadsheetML workbook

  • 5 Match the formatting of the destination document, if the source file is a SpreadsheetML 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:
{ LINK Excel.Sheet.8 "C:\\My Documents\\Profits.xls"
   "Sheet1!R1C1:R4C4" \a \p }