Printing Multiple Workbooks through Master Document?

Giganews Newsgroups
Subject: Printing Multiple Workbooks through Master Document?
Posted by:  ScottP33 (anonymo…@discussions.microsoft.com)
Date: Wed, 15 Oct 2003

Word has a facility to pull together multiple documents
into one "master" document. I have 120 separate workbooks
that need to be grouped and printed in specific orders.
Unfortunately that order changes monthly. In order to
print easily does Excel have master document capabilities
or would a macro openening and closing specific files from
an input source be better? I've tried linking and
inserting the print ranges into a workbook but this has
not worked. Suggestions?

Replies