EMBED

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
Back
Top