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!


--
guillemot
------------------------------------------------------------------------
guillemot's Profile: http://www.excelforum.com/member.php...o&userid=29833
View this thread: http://www.excelforum.com/showthread...hreadid=508726