EMBED

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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