ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   EMBED (https://www.excelbanter.com/excel-discussion-misc-queries/128547-embed.html)

Platypus

EMBED
 
I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance

Dave F

EMBED
 
Well, I don't think that the EMBED function is meant to produce
printer-friendly layouts of Word documents. Perhaps put a message in large
type at the top of the Word document saying that it should be saved to the
user's local drive, opened in Word, and printed from there.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance


Platypus

EMBED
 
How about pasting via a text box? Is there anyway to keep the formatting
between applications when using a text box? Specifically, bullets, margins,
and numbering?

Thanks

"Dave F" wrote:

Well, I don't think that the EMBED function is meant to produce
printer-friendly layouts of Word documents. Perhaps put a message in large
type at the top of the Word document saying that it should be saved to the
user's local drive, opened in Word, and printed from there.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance


chefmike

EMBED
 
I have had success with "Insert" "object" "Word Document" you might try this

"Platypus" wrote:

How about pasting via a text box? Is there anyway to keep the formatting
between applications when using a text box? Specifically, bullets, margins,
and numbering?

Thanks

"Dave F" wrote:

Well, I don't think that the EMBED function is meant to produce
printer-friendly layouts of Word documents. Perhaps put a message in large
type at the top of the Word document saying that it should be saved to the
user's local drive, opened in Word, and printed from there.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance


Platypus

EMBED
 
I've done that; the issue is that it won't insert multiple pages.

"chefmike" wrote:

I have had success with "Insert" "object" "Word Document" you might try this

"Platypus" wrote:

How about pasting via a text box? Is there anyway to keep the formatting
between applications when using a text box? Specifically, bullets, margins,
and numbering?

Thanks

"Dave F" wrote:

Well, I don't think that the EMBED function is meant to produce
printer-friendly layouts of Word documents. Perhaps put a message in large
type at the top of the Word document saying that it should be saved to the
user's local drive, opened in Word, and printed from there.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance


Dave F

EMBED
 
I don't think Excel (or any office application) is designed in that manner.
And I don't believe inserting a Word document into a text box will retain its
formatting.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I've done that; the issue is that it won't insert multiple pages.

"chefmike" wrote:

I have had success with "Insert" "object" "Word Document" you might try this

"Platypus" wrote:

How about pasting via a text box? Is there anyway to keep the formatting
between applications when using a text box? Specifically, bullets, margins,
and numbering?

Thanks

"Dave F" wrote:

Well, I don't think that the EMBED function is meant to produce
printer-friendly layouts of Word documents. Perhaps put a message in large
type at the top of the Word document saying that it should be saved to the
user's local drive, opened in Word, and printed from there.

Dave
--
Brevity is the soul of wit.


"Platypus" wrote:

I am trying to insert a multi-page Word document into an Excel sheet.
However,:

- If I use the EMBED function from the insert menu, it only inserts the
first page so that it is visible. It will display the entire document if I
double click the cell; but, I need to have it be print-friendly.

- If I copy and paste the document, it throws all the formatting off. Going
back in to reformat is not acceptable as I will have to update this workbook
on an annual basis.

Thank you in advance



All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com