merging documents,exporting long landscape table to word with page breaks & numbers

[guillemot]

Hi all,

Time sensitive questions here.

2 big questions:

(1) Can I merge a group of word and excel documents someshow so they
print together with continuous page numbering and formatting and with a
common table of contents? i.e. can I make a word doc with some magic
code in it that automatically pulls them all together?

(2) Can I force the page numbers on a printed excel document to go
where they don't seem to want to? (see below)

Background and details:

I am taking my first stab at using the formatting features in word
(i.e. Header styles that allow auto-generation of a table of contents,
etc...) as I assemble the chapters, tables, and appendices of my thesis
into one large document.

One long appendix (37pp) has to be landscape oriented, but the page
numbers still have to go along the short edge of the page (portrait
oriented) as they do in the rest of the book. I have used the "repeat
rows at top of page" option in page setup to keep my headers consistent
throughout the document. I don't want to do the tedious copy and "past
special" method for such a long appendix, as it will inevitably need to
be modified in future drafts.

I'd like to keep chapters 1-3(.doc) and appendices 1 and 2(.xls) as
separate files that I can modify but have some repeatable means of
pulling them all together as described above without just copying and
pasting them into one word doc, as that seems to make trouble with the
word styles and formatting, I can't just past a 37 page table sideways
into word, and the combined document is just too long to deal with.

That was long, I know, but I'd appreciate any advice offered with this
as I'm coming down to the wire here!!
Thanks!

 

[Pete]

In your Word document for the Appendices, why not have several blank
pages (enough for the Excel tables to print on) and print these out
with headers/footers how you would like them. Then feed these pages
back into the printer and overprint them with the Excel tables (in
landscape mode) ensuring that the margins on the Excel tables are wide
enough to miss the headers/footers - you do not need headers & footers
in the Excel files, though you might still need Rows repeating to
include table headers etc. You might need to feed the header/footer
pages in to the printer upside down to get the correct orientation of
the tables.

Hope this helps.

Pete

 

[guillemot]

Pete,

I think could work! At least for a printed copy (my most pressing
need). However, I also want to make this whole thing into a single pdf
file, so I'll still need to get page numbers on the appendices somehow.
Any thoughts on that or on the document merging question?

Jeff

 

[Pete]

If you had a DTP package you would be able to orient the tables in
landscape and have the headers/footers in portrait, and you could
produce a PDF file from this - I don't think you could do this in Word.

Pete

 

[Pete]

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