LINK classname "filename" [placereference] [switches]

Links information you copied from another application to the original source file using OLE.


classnameThe application type of the linked information
For example, for a Microsoft Excel chart, ClassName is "ExcelChart." Word determines this information from the source application.
filenameThe 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"
placereferenceIdentifies 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.
\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.

REMARKS
* 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.
* If you want to have manual updating do not include the \a switch.
* For the Microsoft documentation refer to support.microsoft.com

Examples

{ LINK Excel.Sheet.8 "C:\\My Documents\\Profits.xls" "Sheet1!R1C1:R4C4" \a \p }
{ LINK Excel.Sheet.8 "\\\\intranet.company.com\\location\Workbook.xlsx" "Sheet1![Workbook.xlsx] Sheet1 Chart2" \p }
{ LINK Excel.Sheet.12 }

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top