Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert large excel object into word | Excel Discussion (Misc queries) | |||
Word with embedded Excel object which has reference to addin | Excel Discussion (Misc queries) | |||
How to fix a Excel corrupt object pasted into Word? | Excel Worksheet Functions | |||
Print more then one page in excel from a word object | Excel Worksheet Functions | |||
Excel Object copied to Word not printing in color | Excel Discussion (Misc queries) |