Insert Object

[Guest]

I am trying to insert the contents of a 2 page Word File into an Excel
Worksheet using Insert Object but only the first page of the document appears
in the Excel Worksheet. Anyone help?

 

[garfield-n-odie [MVP]]

An inserted object cannot span more than one page. A workaround is to
open the Word document in Word, select and copy the first page, paste it
into Excel as a Word object by clicking on Edit | Paste Special | Paste
as: Word object | OK, select and copy the second page in Word, and paste
the second page into Excel as a Word object. The disadvantage of this
method is that the entire Word file is embedded into Excel each time you
paste as an object, even though only one page shows, so the size of your
Excel file will increase.

 

[Guest]

Thanks :~}

An inserted object cannot span more than one page. A workaround is to
open the Word document in Word, select and copy the first page, paste it
into Excel as a Word object by clicking on Edit | Paste Special | Paste
as: Word object | OK, select and copy the second page in Word, and paste
the second page into Excel as a Word object. The disadvantage of this
method is that the entire Word file is embedded into Excel each time you
paste as an object, even though only one page shows, so the size of your
Excel file will increase.