Print Word Object in Excel

[Guest]

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]

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

 

[Guest]

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]

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

 

[Guest]

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]

Pasted into Excel?

Yep. I didn't say it was easy. You can always take the time to clean it up in
excel.

If you want to stick with an embedded document, you can print all the pages by
double clicking on that object and printing from there.

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=

 

[Guest]

Dave:

I appreciate your time and effort, but we are going nowhere with this thread.

1) A Word document pasted into Excel cannot be "cleaned up" easily because
most paragraphs of text exceed the cell character limitation.

2) If you print an embedded document as you suggest, the headers, footers,
and pagination come from Word, not from Excel.

Can anyone else give me some assistance with this?

=Mac=

 

[Dave Peterson]

I never said it was easy.

Dave:

I appreciate your time and effort, but we are going nowhere with this thread.

1) A Word document pasted into Excel cannot be "cleaned up" easily because
most paragraphs of text exceed the cell character limitation.

2) If you print an embedded document as you suggest, the headers, footers,
and pagination come from Word, not from Excel.

Can anyone else give me some assistance with this?

=Mac=