Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Montreal, Quebec, Canada
    Posts
    115
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Special characters that don't stick in Word (Office 2000/Win XP)

    Hi Gang,
    I have an Excel file that has special characters in it. When I bring it into Word (as a Microsoft Excel Object) certain characters show up as ???. If I do a plain paste in Word everything is fine. These are the names of certain communes in Viet Nam (i.e. Kỳ T

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

    Re: Special characters that don't stick in Word (Office 2000/Win XP)

    Hi,

    Try linking the data as RTF or HTML text via Edit|Paste Special. Both of these can generate a tabular representation of your Excel workbook, but in a Word table. Note, too that Word's Edit|Paste Special linking is version specific, as it embeds the version number (eg 7, 8 or 9) in the field. I don't know if this causes compatability problems with earlier versions.

    To do the linking manually and avoid any potential versioning issues, name the range you want to refer to, then create a LINK field like:
    {LINK Excel.Sheet "C:My DocumentsTest.xls" "Named range" a h}
    for HTML or
    {LINK Excel.Sheet "C:My DocumentsTest.xls" "Named range" a r}
    for RTF. The a switch tells word to automatically update the links, which unfortunately doesn't get added if you simply use Edit|Paste Special HTML/RTF

    Cheers
    PS: Note the double backslashes separating the folder names in the path.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Special characters that don't stick in Word (Office 2000/Win XP)

    Hi macropod:
    I recently learned that you can replace double backslashes in field pathnames (e.g. Includetext, Includepicture, & Link fields) with single forward slashes. Both work identically, as far as I can tell.
    Cheers,

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

    Re: Special characters that don't stick in Word (Office 2000/Win XP)

    Hi Phil,

    Interesting observation - I'll have to check it out sometime. The only reason that the double backslash has been required is because the backslash character is treated as a special/switch character in a field, rather like double quotes in other contexts. For my own part, I've found that a path solicited via an ASK field works in INCLUDE fields etc with only the single backslash. Can't quite figure that one out ... could be something to do with Word process the bookmark as a string without inspecting it for backslashes.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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