R
Robin Clay
Greetings !
I have a spreadsheet, from which I have to abstract
(from two different WorkSheets) two tables
each extending to about 2,700 rows long by 18 columns
wide,
and include them into a WORD document.
Each will therefore run to some 45 pages,
so I want the top three rows to appear
as a heading on every page.
One will be Appendix A and the other Appendix B.
What I would like to do is to have a VBA routine
such that I can simply place the cursor in the WORD
document,
then Alt-Tab into the Excel WorkBook,
select the entire area that I want to copy,
and then click on a ToolBar Button.
I will be asked how many rows I want as Header,
and the data will be pasted automatically at the
cursor position in the Word Document
in the right number (45) of different bits, one per page.
When I tried an ordinary cut 'n' paste, WORD crashed....
I guess I was trying to paste too much data.
I have a spreadsheet, from which I have to abstract
(from two different WorkSheets) two tables
each extending to about 2,700 rows long by 18 columns
wide,
and include them into a WORD document.
Each will therefore run to some 45 pages,
so I want the top three rows to appear
as a heading on every page.
One will be Appendix A and the other Appendix B.
What I would like to do is to have a VBA routine
such that I can simply place the cursor in the WORD
document,
then Alt-Tab into the Excel WorkBook,
select the entire area that I want to copy,
and then click on a ToolBar Button.
I will be asked how many rows I want as Header,
and the data will be pasted automatically at the
cursor position in the Word Document
in the right number (45) of different bits, one per page.
When I tried an ordinary cut 'n' paste, WORD crashed....
I guess I was trying to paste too much data.