trouble linking large worksheets to Word

[swingkyd]

I cannot seem to resolve the following problem:

Description of situation:
I have a large Word document with appendices. Within the appendices I need to link a rather large (10-20page) table that has been created and formatted well in Excel.

I want to include this table within word so that it retains the header and footer of the appendix and the rest of the document (including the page numbers and stuff).

Unforntunately when I select the appropriate range in Excel, copy and paste as a link to an Excel Object, the whole object gets put in one page... and I can't see most of it anyway. I haven't been able to split this object up.

Is there any way for word to "actively" split the object over the pages (similar to how it deals with it's own tables split over pages... retaining the header at the top of the page ...)? I need to keep the first row at the top of the pages too.

I've already tried to paste it as an rtf link which didn't keep the merged cells within the worksheet which messed everything up.

VBA application:
I am hoping to create VBA code that can be executed to perform these tasks either by grabbing the information from the copy "clipboard" or through a form.

Unfortunately I really don't know where to start since I can't seem to break up an object within Word. Otherwise I'd record a macro and edit the code...

Some help would be GREATLY appreciated!!!

 

[swingkyd]

I still can't figure this out...can someone help me?
I was thinking that I could set up a little script to count how many rows will fit within the title block of the page to insert... then try to grab incremental "sections" of the table until I reach the end. Then make object links from the excel sheet to the word report.

This would give me a bunch of different links within the document.

This seems all too complicated. Any ideas?

any thoughts would be greatly appreciated!