Solved Tool for combining PDFs
- Thread starter nrgins
- Start date
cheekybuddha
AWF VIP
- Local time
- Today, 13:39
- Joined
- Jul 21, 2014
- Messages
- 2,661
What version of Access do you have?
If you have access to the new Web Browser control perhaps this might be of interest?
If you have access to the new Web Browser control perhaps this might be of interest?
cheekybuddha
AWF VIP
- Local time
- Today, 13:39
- Joined
- Jul 21, 2014
- Messages
- 2,661
Did you visit the link?
OK, I downloaded the sample app and took a look at it. I see that it makes use of an html file "index-merge.html" that does the work, allowing the user to select files and click a button to merge them. Very cool!
Unfortunately, I need something completely under the hood, done exclusively within VBA, without user interaction.
Thus, I don't think that would work for me as-is.
cheekybuddha
AWF VIP
- Local time
- Today, 13:39
- Joined
- Jul 21, 2014
- Messages
- 2,661
I haven't looked at the sample, but can't you just perform all the actions that are done via the form in VBA?
Unfortunately my version of Access is so old that I can't use the new browser control.
I'll try and have a look at the sample anyway to see if it's possible from the code if I get a moment later (or someone else might in the meanwhile)
Unfortunately my version of Access is so old that I can't use the new browser control.
I'll try and have a look at the sample anyway to see if it's possible from the code if I get a moment later (or someone else might in the meanwhile)
No, the controls aren't in Access. They're in the HTML file. Access is simply hosting the HTML file in the web browser control.
I mean, maybe there's a way to use it programmatically by setting the text box values and activating the button. And if someone knows how to do that, then that would be great to hear.
Also, the tool allows for up to two PDFs to merge together. I need to merge about six. I mean, I guess I could do it multiple times, two files at a time.
I mean, maybe there's a way to use it programmatically by setting the text box values and activating the button. And if someone knows how to do that, then that would be great to hear.
Also, the tool allows for up to two PDFs to merge together. I need to merge about six. I mean, I guess I could do it multiple times, two files at a time.
With PDFtk Server (command line tool) you can merge several PDFs into one.
cheekybuddha
AWF VIP
- Local time
- Today, 13:39
- Joined
- Jul 21, 2014
- Messages
- 2,661
Stephen Lebans' overall PDF creation solution no longer works, but parts of it do. Among other things, one of the two DLLs can be used to merge PDF files. Just copy the DLL to the application directory without any installation/registration.
Thanks everyone for the replies.
I found a solution that works for me by the awesome Albert Kallal, as noted here.
This is a very simple solution that only requires putting a couple of DLLs on the system, and everything else is handled with a few lines of VBA code. So, a very clean, simple solution that is just what I was looking for.
Thanks again, everyone.
I found a solution that works for me by the awesome Albert Kallal, as noted here.
This is a very simple solution that only requires putting a couple of DLLs on the system, and everything else is handled with a few lines of VBA code. So, a very clean, simple solution that is just what I was looking for.
Thanks again, everyone.
In order to present something as the "best solution", requirements from a development environment such as Access should be met. A key requirement would be code-controlled access via an accessible object model or via command lines. I have enough user interface in my access frontend, as changing the UI is counterproductive.
Similar threads
