LINK classname "filename" [placereference] [switches] |
Links information you copied from another application to the original source file using OLE. |
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. |
\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