I want to embed an financial statement into Word that is several pages long.
How do I embed into word and make it several pages in length, instead of it
just being the picture of the whold document in one page? Thanks!
I am using Office 2003 products
TedMi - 30 Dec 2005 19:28 GMT
In Excel, select the extent of cells you want to appear in the doc and Edit |
Copy to the clipboard.
In Word, position the cursor where the statement is to begin, Edit | Paste
Special, check Paste Link, select RTF, OK.
That creates a Word table in the doc, linked to the data in the worksheet.
Each time you open the doc, you will be asked whether to update the linked
data. Thus, changes to the spreadsheet will be reflected.
You may have to play with the table's formatting - font, column widths, etc.

Signature
Ted
Doug Robbins - Word MVP - 30 Dec 2005 19:29 GMT
It is not possible for an object in Word to span multiple pages.
You would need to embed a page worth's at a time.

Signature
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
>I want to embed an financial statement into Word that is several pages
>long.
[quoted text clipped - 3 lines]
>
> I am using Office 2003 products