+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    12-22-2005
    Posts
    11

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

    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!
    Last edited by guillemot; 02-05-2006 at 12:24 PM. Reason: changed title

  2. #2
    Pete
    Guest

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

    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


  3. #3
    Registered User
    Join Date
    12-22-2005
    Posts
    11
    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

  4. #4
    Pete
    Guest

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

    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


  5. #5
    Pete
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1