darrell eichman
asked on
MS Access VBA - Combining PDFs
Our setup is as follows: MS Access 2007 and MS Access 2013
Monthly 6000+ PDFs that are combined to about 500 PDFs based on various criteria. The PDFs page range is 10 - 100 pages so the final combined PDF can reach 400 pages.
Solutions Tried:
1. Acrobat Controls: Pros - Works fine, Cons - Slow, Expensive to have the controls on the server.
2. IrFanView - Using Access to create a batch file files (.bat) then run IrFanView to combine the files. Pros - Cheaper, Faster than Acrobat. Cons - PDF is degraded
I'm looking for a solution to combine PDFs in an efficient manner. Acrobat is too slow in appending each file and expensive. IrfanView's results is a degraded PDF, sometimes being illegible.
What kind of tools can you recommend to combine multiple PDFs into a single PDF? I prefer a tried and proven solution, not academic.
Monthly 6000+ PDFs that are combined to about 500 PDFs based on various criteria. The PDFs page range is 10 - 100 pages so the final combined PDF can reach 400 pages.
Solutions Tried:
1. Acrobat Controls: Pros - Works fine, Cons - Slow, Expensive to have the controls on the server.
2. IrFanView - Using Access to create a batch file files (.bat) then run IrFanView to combine the files. Pros - Cheaper, Faster than Acrobat. Cons - PDF is degraded
I'm looking for a solution to combine PDFs in an efficient manner. Acrobat is too slow in appending each file and expensive. IrfanView's results is a degraded PDF, sometimes being illegible.
What kind of tools can you recommend to combine multiple PDFs into a single PDF? I prefer a tried and proven solution, not academic.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I used Primopdf to do the appending of pds but never used something else so I dont know if it is slow or fast, it just worked for the purpose at that time
DynaForms has a great PDF library called DynaPDF https://www.dynaforms.com/en/home.html
I have been using the free Report to PDF tool by Stephen Lebans with Acess 2003, 2007, 2010, 2013 to combine PDFs. with the included DynaPDF.dll for distribution.
I have one client location that used it on a terminal server with 10+ users combining PDFs. The users will combine on average 10 to 15 PDFs with the final PDF averaging over 100 pages.
I have been using the free Report to PDF tool by Stephen Lebans with Acess 2003, 2007, 2010, 2013 to combine PDFs. with the included DynaPDF.dll for distribution.
I have one client location that used it on a terminal server with 10+ users combining PDFs. The users will combine on average 10 to 15 PDFs with the final PDF averaging over 100 pages.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the recommendations. So far, DynaPDF looks the most promising. Over the next week, I'll evaluate it and let you know.
If you have additional ideas, please send. Thanks!
If you have additional ideas, please send. Thanks!
@darrell,
Are you all set with this now, or do you need more help? If all set, could you please close it out now. If you need help with the question close process take a look at:
»bp
Are you all set with this now, or do you need more help? If all set, could you please close it out now. If you need help with the question close process take a look at:
»bp
»bp