Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Insert XL cell contents into Word document (WinNT/Word97)

    I have a user who has a word document which is basically a letter with some customised information in the middle of it; the customised info is held in an XL spreadsheet and is always in the same place (ie sheet SingleCustomerInfo cells D512). The contents of each cell is in a cell in a table in Word, ie table cell A2 contains XL D5, table A3 contains XL D6, etc.

    What she would like is for the Word document to automatically contain the current contents of those cells when it is opened (and to update when the cells are changed).

    I thought of Word fields (and F9 to update when changed) but although I've found INCLUDETEXT this seems to be able to bring in only an entire workbook, not just specific cells; is there a way to do this or am I barking up the wrong tree entirely?!

    Any asistance gratefully appreciated <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>
    Beryl M


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

    Re: Insert XL cell contents into Word document (WinNT/Word97)

    Hi Beryl,

    With Excel and Word both open, try copying the cell then using Edit|Paste Special and using the "Paste Link" option with whatever format you want (RTF works well for a single cell).

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Insert XL cell contents into Word document (WinNT/Word97)

    Thanks, macropod - perfect! And a lot simpler than I thought it would be!

    <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Beryl M


Posting Permissions

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