Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any advice on combining Excel and Word documents into one PDF?
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Any advice on combining Excel and Word documents into one PDF?
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. "Frustrated" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging documents with Word and Excel | Excel Discussion (Misc queries) | |||
Printing Word Documents from Excel | Excel Discussion (Misc queries) | |||
Too many word documents, can Excel HELP!!! | Excel Discussion (Misc queries) | |||
combining word documents and excel worksheets | Excel Discussion (Misc queries) | |||
Ever use Excel for documents instead of Word? | Excel Discussion (Misc queries) |