Embedding Word in Excel

[mplsken]

I looked around for the right discussion thread to post this to, and apologize if this is the wrong one ... feel free to redirect me - I'm new to this board!

I've seen several references in other postings talking about embedding Excel in Word documents, but I am trying to create a Requirements template where the first tab represents the high-level requirements for a release - these tend to be very verbose and include the justification for the requirements ... a format that Word is better-suited to. The later tabs are the detailed requirements, issues, assumptions, glossary, and appendix, all of which are MUCH better suited to Excel (the Nazi in me really wants to discourage verbosity in the detailed requirements).

When I attempted to embed Word in Excel, only the first page of Word appeared in the tab, and while I can navigate around the Word doc within that one page by activating the object (double-clicking on it), printing that tab only gives the page that is visible in the non-activated object. If I can get the first tab to "be" a Word document and all the other tabs continue to "be" Excel, where clicking "Print Workbook" sends all the content to my printer, my problem is solved. Any tips???

(Please don't suggest that we just buy a tool to manage our requirements unless you're going to give me something free that scales to four locations and roughly 500 analysts/developers/testers)

[Killer42]

One option (probably not one you'll like much, but we'll see) is to copy and paste each page separately (Paste Special -> MS Word Document object). If you use Paste Link they will still be pointing to the original document, and so should be kept up to date.

Oh, and by the way, you might try posting this in the Community Cafe or Techie Talk forums, for a larger cross-section of the IT community.