Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 2nd 07, 07:11 AM posted to microsoft.public.excel.misc
Mac Mac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 213
Default Print Word Object in Excel

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=


  #2   Report Post  
Old March 2nd 07, 02:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Print Word Object in Excel

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
  #3   Report Post  
Old March 2nd 07, 03:03 PM posted to microsoft.public.excel.misc
Mac Mac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 213
Default Print Word Object in Excel

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

  #4   Report Post  
Old March 2nd 07, 03:15 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Print Word Object in Excel

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
  #5   Report Post  
Old March 2nd 07, 03:49 PM posted to microsoft.public.excel.misc
Mac Mac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 213
Default Print Word Object in Excel

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



  #6   Report Post  
Old March 2nd 07, 04:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Print Word Object in Excel

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
  #7   Report Post  
Old March 2nd 07, 05:54 PM posted to microsoft.public.excel.misc
Mac Mac is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 213
Default Print Word Object in Excel

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

  #8   Report Post  
Old March 2nd 07, 06:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert large excel object into word BIZBRKR Excel Discussion (Misc queries) 2 January 7th 07 04:46 PM
Word with embedded Excel object which has reference to addin Tom Chau Excel Discussion (Misc queries) 0 September 6th 06 02:25 AM
How to fix a Excel corrupt object pasted into Word? hazel Excel Worksheet Functions 1 July 28th 06 06:57 PM
Print more then one page in excel from a word object Alex Martinez Excel Worksheet Functions 0 October 14th 05 06:22 AM
Excel Object copied to Word not printing in color dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:40 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017