Dave:

Have you ever pasted a document into Word?

1) If you paste all text from a Word document, each paragraph is pasted to
a cell in a single column (unless you have hyperlinks in the document). The
text does not display if the text in the paragraph exceeds Excel's limits.
2) If you paste the text as a Picture, it looks fine, but cannot be modified.
3) If you embed or link a Word object, you can only print a single page
(the first page) of a multi-page document because of OLE limitations.

None of these options is acceptable.

=Mac=


"Dave Peterson" wrote:

Have you considered just copy|pasting all the word document's text into an
Instruction worksheet--just keep the text in excel?

Mac wrote:

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


--

Dave Peterson