asked on

Merge adobe acrobat files automatically

Hello Experts!

I've seen a couple of quesitons on merging PDF files but have not seen an answer that addresses my scenario (have I missed something?).

I need to automatically merge a series of pdf files into a single acrobat file in a particular sequence specifed by the boss. The sequence will change as new reports are added or old ones are removed.

I have around 24 report files total right right now that I have to merge manually in a partcular sequence every week sometime many, many times in a week with new versions of the reports.

Prefer if this can be done using VB Script or VBA simply because I have worked with those and know how to call or integrate from MS Access 2003 as part of a report macro or code module. However I believe I read that the Adobe API uses Java so whatever gets the job done, I just may need a few pointers to get another language to work.

I have Acrobat Pro 9 installed on my PC.

Thanks for any help!

Robberbaron (robr)

i would be using the pdftk commandline app http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/ because i know how to script it via commandline parameters from vba etc

matttclark

ASKER

I can install that if you give me the script! thanks

aikimark

Do the file names provide you with enough information to properly sequence the PDFs for the concatenation process?

matttclark

ASKER

aikimark,

not sure..how about a sample?
report/filenames

1.      Adonis SPP
2.      Adonis SPP summary
3.      HTC SPP
4.      HTC SPP Summary
5.      Belkin SPP
6.      Belkin SPP Summary
7.      Notes and Changes
8.      Cover
9.      TOC
10.      Division 1000 Summary
11.      Division 1100 Summary
12.      Division 1200 Summary
13.      FS Managers summary
14.      FS All customers
15.      FS By code

Sequence is manually set and with this sampling is 8, 9, 7, 10, 11, 12, 5, 6, 1, 2, 3, 4, …etc

thanks!

ASKER CERTIFIED SOLUTION

aikimark

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

matttclark

ASKER

aikimark-wow thanks for the effort.

was not familiar with PDF SAM but googled it and am reading up on. will download and install on work PC on Monday and run through your bat file!

let me get back to you then, have a good rest of the weekend! thanks again.

Robberbaron (robr)

I too was not aware of PDF-SAM.
While PDFTL will do the job, given the number of fields you wish to merge the PDF_SAM ability to read input from a CSV file is a big advantage.
And means the batchfile is independent of the input.

matttclark

ASKER

sorry for the delay. won't be able to get this installed on Office PC for a week or two (corporate IT), but based on everything I've read, this shoudl do the trick.

thanks again!