help to split a table across pages = word 2002

T

Techno Grandma

I have a form that brings in data from an excel worksheet. I want to have
the excel worksheet insertion split and go on two pages if there is not
enough room on the first word page. Now if I add any lines to the
spreadsheet, which is variable and sometimes can go 2 the table will not
split over the pages. Do I have to do this somehow in Word or in the Excel
document?
 
C

CyberTaz

I have no idea what the mechanics of the "form" are, but you are right that
an object - picture, embedded or linked file, etc. - cannot span a page
break in a doc. The Excel data needs to be brought in as Formatted Text
(RTF) which will generate a Word table. Tables can span multiple pages.

Another option might be to have 2 separate objects created - each on a
separate page & each containing only a portion of the data. Don't know if
your process can accommodate that or not.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
T

Techno Grandma

Thanks Bob I think the solution is to bring the information over as
formatted text. Can you explain how this works. Thanks
 
C

CyberTaz

I can't give you specifics for automating the process as I am not familiar
with what your current workflow entails. The most straightforward method (if
it's available) is to open the Excel file itself, select & copy the required
range of data, then in the Word doc use Edit> Paste Special - Formatted
Text. The pasted content will be inserted into the doc as a formatted Word
Table based of the formatting used in the worksheet.

How you might go about automating - if necessary - would best be addressed
by your staff or consultant.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
T

Techno Grandma

The excell workbook is an accounts receivable journal, the data is going from
an invoice worksheet to a Word document with Company letter head logo and
comments built in.
Using the copy/paste option is doable, however it would be nice to have a
way of this happening automatically when you open a new Word template called
invoice.
Any suggestion? A macro set in a table?
Thanks for your suggestions so far I will test them out.
 
T

Techno Grandma

The cut paste works is there a way to set a table in a word document that
would have a macro bring in the selected information from an excel worksheet?
THANKS
 
Top