View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Print Word Object in Excel

I never said it was easy.

Mac wrote:

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" wrote:

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.



Mac wrote:

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


--

Dave Peterson


--

Dave Peterson