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