Any advice on combining Excel and Word documents into one PDF?

[Frustrated]

Hi,

I don't know if this is the best forum for this, but I'll give it a shot.
We have a budget system that consists of an Excel workbook with numerous
worksheets and four Word documents. I need to create a PDF file that
contains all of the worksheets and documents.

Here is my problem. The four documents need to be inserted between various
worksheets (each document in a different spot). This system is used by
approximately 65 users. The PDF file needs to contain all the worksheets and
documents, in the correct order, for user 1, then for user2, user3, etc.

Right now this is being accomplished in steps. I have an Excel macro that
opens each of the 65 workbooks and prints their spreadsheets out to a PDF
file. I also have a Word macro that opens all 260 Word documents (4 docs per
65 users) and prints each of these to a PDF file. We then manually merge the
65 Excel PDFs and 260 Word PDFs into a single PDF file.

As you can imagine, this is very tedious and labor intensive. Does anyone
have any ideas on how these steps could be combined? Ideally I'd like some
kind of Macro that could automatically merge the spreadsheets and documents
into a single PDF.

I've thought about trying to embed the spreadsheets in a Word document, but
most of them span multiple pages when printed, and I can't figure out how to
get an embedded spreadsheet to page break. The spreadsheet size will vary by
user as well, so I can't assume something like "spreadsheet 2 is always 2
pages wide by 3 pages high".

Thanks for your help!

 

[Sheeloo]

You (or someone you can get) need to write a VBScript code which will pick up
each file, append its print output to the designated pdf file...

If you know programming you may refer to
http://www.adobeforums.com/webx/.59b58eb6 to see how it is done for one file.
You will need to find out how to append to a file and loop through your files.