merging documents,exporting long landscape table to word with page breaks & numbers
Further thoughts:
If you do <ALT<PrintScreen you copy a "picture" of the current window
to the clipboard, which can then be pasted into Word. So, if you can
arrange your Excel window to display the part of the table which you
want to see on one page, this may be one way to achieve what you want.
You can hide the scroll bars and row/column identifiers in Excel
beforehand, or you can crop these from the image in Word, where you
might be able to rotate the image to get landscape orientation
(although I couldn't rotate a small image when I tried just now).
This would be a bit tedious if you have 37 pages, as you would
obviously have to repeat this for each page, but it is possibly another
way to do what you want.
Hope this helps.
Pete
|