Linking multipage Word doc into Excel

[Guest]

I have Word documents that are two pages long that I am trying to link
(inserting as an Object) into an Excel worksheet. I can only bring over 1
page at a time and it doesn't retain the outline numbering sequence I had in
Word. Is there a way to bring the ENTIRE Word doc into Excel as an Object.

BTW...the link works like a charm with all the single page Word files
objects I've done.

 

[Cindy M.]

Hi =?Utf-8?B?TGFkeSBMYWZhbG90?=,

I have Word documents that are two pages long that I am trying to link
(inserting as an Object) into an Excel worksheet. I can only bring over 1
page at a time and it doesn't retain the outline numbering sequence I had in
Word. Is there a way to bring the ENTIRE Word doc into Excel as an Object.

I think you'll find all the pages are there, but the OLE control only displays
the one page. This is by design and there's nothing you can do to change it.

So you'll have to select/copy and paste link twice, once for each page. To
retain the numbering you have two possibilities.

1. Most reliable. Create two sets of numbering that look identical. Link each
to a separate style. Set the numbering for the second page to start at the
appropriate number (rather than 1).

2. Select the numbering on the second page and set it to "restart". Then change
the numbering format to restart at the desired number.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail