Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Los Angeles, California, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insert Word doc to Excel (Excel97)

    I am attempting to insert an object from a file, a multi-page word document, into an XL workbook and all I get is the first page of the word doc. I get the same result if I copy & paste special as a word doc or as a picture (enhanced metafile). The graphics don't paste if I try to just paste the document into excel. Is there a way to get the each page of the word document without having to copy it page by page?

    Thanks,
    cg

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Insert Word doc to Excel (Excel97)

    Can you explain why you want to do this? Perhaps someone will have an alternate solution.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Location
    Los Angeles, California, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Word doc to Excel (Excel97)

    Thanks for the interest, WebGenii. I have an assortment of related word docs and xl files that I would like to incorporate into a single, master xl file. The word doc's include graphics and I'm trying to avoid recreating them in xl. Alternate solutions are welcome!

    cg

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

    Re: Insert Word doc to Excel (Excel97)

    I don't think including a Word document in an Excel spreadsheet is a very good idea. I'd do it the other way round: include tables and/or charts from the Excel spreadsheet in the Word document.

    Another possibility is to use Microsoft Binder (although I've never been a fan of it). A Binder is a container document that can contain Word documents, Excel spreadsheets and PowerPoint presentations. A Binder can be printed as if it is one document.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Insert Word doc to Excel (Excel97)

    I'd agree with Hans. You are letting yourself in for a lot of annoyance - stuffing word docs into excel.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Insert Word doc to Excel (Excel97)

    Resurrecting this old thread, somebody just sent me what initially appeared to be a multipage embedded Word document. So I jumped in to find how they did it, and <img src=/S/doh.gif border=0 alt=doh width=15 height=15>, they embedded the same doc four times scrolling each embedding to consecutive pages so it looks like a continuous document, and I assume they carefully lined the embedding positions up so it looks like a single document, but it's definitely four embedded Word objects pointing to the same doc, one for each page.

    Another one for the "why didn't we think of the obvious" tip sheet. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    New Lounger
    Join Date
    Feb 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Insert Word doc to Excel (Excel97)

    Hey! How do you do that? In Word/Excel2000 and XP the same problem.

    In word, select all, copy.

    In excel, insert object - word doc, then paste. So far, so good.
    Move down on worksheet and insert another object and paste.
    Both object show page 1 of word doc.
    Doubleclick obj2, scroll down to page 2, click outside the box
    and POOF, it jumps back to display page 1.

    I found that by fooling with Format Object, Size and negative cropping,
    the page can look just like in word, and by dragging the bottom down, it can even show the word footer, but no luck getting it to stay on page 2.

    My reason for wanting this is to edit my userguide in word, with nice formatting and style thingies, implant it in my fantastic excel macro which can be delivered to the client as a single file with the userguide showing up on the worksheet when then open it.

    All nicely contained in one file.

    Any ideas?

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Insert Word doc to Excel (Excel97)

    Ahem, it wasn't done the way I thought. What you and I have been doing is posting the entire document through the Insert Object dialog, and browsing to the Word file. That method doesn't let you show any page other than the first, and you can only display the object the size of the first page.

    Here's how to do what I think you want:

    Copy, -page by page- from the Word document, switching to Excel and back, and at each location in Excel you wish the page to appear, paste it through either

    1. "Edit, Paste Special, Microsoft Word Document Object" and check the Paste button, or

    2. "Edit, Paste Special, Microsoft Word Document Object" and check the Paste Links button

    The Help states that checking Paste Link inserts the document so that changes are reflected, but in my test, checking Paste allowed the link to update and checking Paste Link did not. One of us is confused, probably me. I think that for the purpose you need this done, you don't need it linked.

    Hope this helps.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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