Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked tables, switches (Win XP, O2003)

    Hi,

    Just struggling a bit here with some linked tables and their settings.
    I'm inserting linked tables from Excel and adding specific formatting. Once F9 updates the fields "things" start to happen.

    I know now that it's the switches that controls this, as my links are fields as shown below.
    - what I'm looking for is some sort of an overview or documentation on the various switches - what they do and how they work.

    Would anyone know where I can find this?

    Examples showing field codes - to illustrate my problem:

    Table with "Automatic updated links (a), not preserved formatting (?),....."
    - but what's the f 4 and h switches doing?
    LINK Excel.Sheet.8 "C:NSXPChartsAndTables.xls" "Tables!R22C3:R26C5" a f 4 h

    Table with "Manual linked updates, preserved formatting (MERGEFORMAT - ?)
    - but again, what's the f 4 , h and * switches doing?
    LINK Excel.Sheet.8 "C_DevelopmentNSXPChartsAndTables.xls" "Tables!R22C3:R26C5" f 4 h * MERGEFORMAT


    Tips or ideas will be appreciated
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked tables, switches (Win XP, O2003)

    These are the switches for the LINK field:

    <table border=0 cellpadding=5><td valign=top>a</td><td valign=top>Updates the LINK field automatically; delete this switch to use manual updating.</td><td valign=top>b</td><td valign=top>Inserts the linked object as a bitmap.</td><td valign=top>d</td><td valign=top>Graphic data isn't stored with the document, thus reducing the file size.</td><td valign=top>f</td><td valign=top>Causes the linked object to update its formatting in a particular way determined by the parameter:</td><td valign=top> f 0</td><td valign=top>Maintain the formatting of the source file</td><td valign=top> f 2</td><td valign=top>Match the formatting of the destination document</td><td valign=top> f 4</td><td valign=top>Maintain the formatting of the source file, if the source file is an Excel workbook </td><td valign=top> f 5</td><td valign=top>Match the formatting of the destination document, if the source file is an Excel workbook</td><td valign=top>h</td><td valign=top>Inserts the linked object as HTML format text.</td><td valign=top>p</td><td valign=top>Inserts the linked object as a picture.</td><td valign=top>r</td><td valign=top>Inserts the linked object in rich-text format (RTF).</td><td valign=top>t</td><td valign=top>Inserts the linked object in text-only format.</td></table>
    * is a general formatting switch, * MERGEFORMAT means that the formatting of the field is (or rather, ought to be) preserved when the field is updated.

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Linked tables, switches (Win XP, O2003)

    Hi Hans,

    FWIW, the f switch is not supported in Word 2000 or earlier. If the OP (using Word 2003) needs to ensure backwards compatability, this might be an issue.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked tables, switches (Win XP, O2003)

    Thanks Hans,

    This was just was I was looking and hoping for.

    ;o) Henrik
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •