[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?

[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



On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:

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?

[Techno Grandma]

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

"CyberTaz" wrote:

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



On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:

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?

[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



On 8/18/07 12:08 PM, in article
, "Techno Grandma"
wrote:


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

"CyberTaz" wrote:

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



On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:

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?

[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.

"CyberTaz" wrote:

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



On 8/18/07 12:08 PM, in article
, "Techno Grandma"
wrote:


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

"CyberTaz" wrote:

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



On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:

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?

[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
"CyberTaz" wrote:

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



On 8/18/07 12:08 PM, in article
, "Techno Grandma"
wrote:


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

"CyberTaz" wrote:

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



On 8/17/07 11:30 PM, in article
, "Techno Grandma"
wrote:

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?