Dave:

Thanks so much for your response.

I actually do that now, but the text changes enough that I have to re-paste
the pages as the text changes.

I am looking for a solution that would automate the process of dealing with
this. This may be a print-time macro or something similar.

Thanks,

=Mac=


"Dave Peterson" wrote:

Split your document into 3 different one page documents and have 3 embedded
documents???



Mac wrote:

Friends:

I have a three page Word object embedded in Excel. Only the first page
prints. I believe this to be a limitation of OLE as implemented in Office.

Can anyone suggest a workaround?

I have multiple worksheets that contain financial data and/or analysis. I
have a worksheet containing the Word object that contains explanatory notes,
etc., to the analyses.

My desire is to print the entire workbook and have a common header and
footer (generated by Excel). The problem is that only the first page of the
Word object prints instead of the entire embedded document.

TIA

=Mac=

--

Dave Peterson