I have hundred's of thousands of TIFF's that I need to merge in multiple PDF's (i.e. lots of scanned pages that have to be merged to recreate their original documents). I have an Excel spreadsheet listing the TIFFs' names and locations and also indicating which PDF file they belong in, (e.g. Tiif's 1-10 are the 1st PDF, 11-75 the 2nd, etc.).
I was happily running a VBA macro using PDFCreator to do this. Unfortunately, PDFCreator appears somewhat tempremental...
- after much mucking about I'm still not absolutely confident that pages will maintain their original sequence.
- for no reason I could ever identify, PDFCreator started producing huge PDF's with all pages in landscape. Each time this happened I had to uninstall and reinstall it.
I tried using ABBY (FineRead 8 Pro). It's good for merging all the TIFF's in a folder into a single PDF, but I would have to select each folder manually and volumes are simply too great for this.
I then experimented with PDFTK (having converted individual TIFF's into single-page PDF's). The problem with this was that there were too many files to specify on the command line and using wildcards doesn't guarantee that the page sequence will be correct.
(1) Is there a bullet-proof way to safely control PDFCreator from VBA?
(2) Is there a better/safer alternative using any mixture of the following...
- Acrobat 8 Standard.
- ABBY FineReader 8 Professional Edition.
- Excel 2007.
- Windows Scripting.
- I could probably get access to Omnipage (a recent full version, but I don't know the number). Not my preferred solution, as I don't have a license, so I'd have to use a colleague's PC after hours.
I'm running XP SP2. The TIFF's are currently in a small number of humungous folders, but I'd have no problem in moving them so that each document's TIFF's were in their own sub-folder.