Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a big book that consist of several static documents and a few dynamic ones (primarily Excel with links). The process of printing all this to one PDF as required by my customer takes way to much time.

What I want is a tool I can use in a batch file that will convert all documents in a folder to PDF and then merge all these PDFs to one big one. All the files have predictable names.

I've been thinking of GhostScript and a WScript, but that dosn't solve printing Excel documents to PDF. Hope you guys have some suggestions?

share|improve this question
add comment

3 Answers

up vote 0 down vote accepted

For printing Excel documents to PDF... If you have Office 2007 or higher you can use the VBscript here.

(You need to create a batch file which loops through your .xls end .docs calling this VBScript.)

After that you can merge the PDF's with PDFTK of or one of the tools from Xpdf or use your own method with Ghostscript.

share|improve this answer
add comment

This is only a partial answer since it doesn't answer the convert part

For batch merge you can try this CMD batch with PDFTK. The output file is always called binder.pdf but that is changeable to a generic name if you need it.

Read full instructions on how to set up

@echo off
setlocal enabledelayedexpansion
FOR %%A IN (%*) DO (set command=!command! %%A)
pdftk.exe %command% cat output "%~dp1binder.pdf"

enter image description here

share|improve this answer
add comment

pdfsam is a multi-platform PDF tool with a pretty comprehensive set of tools for manipulating PDF document orderings. If you can find a way to print off a bunch of PDF documents (doPDF is a great PDF "Printer" if you don't already have one), pdfsam will easily merge all the documents into one.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.