xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Hi,
I've got some co-workers using Acrobat in a long-handed way. They are going through these steps which will be repeated about 14,000 times:
1. Search one long pdf document for a name
2. Print the page
3. Repeat (14,000 times)
The search takes about 10 seconds (alone) on average - so it adds up to a bit of time, with all clicking and waiting for search results.
I'm not at all familiar with coding to Adobe's object model. Does anyone know if it's possible to automate these steps, given a list of names (they come in about 100 at at time in Excel, to be matched and printed). Naturally, the use of names will not be a perfect match so we'd probably need to print all matching names and sort out the duplicates (common names will likely have two or more matches).
Any ideas welcome. Cheers,
xenou
I've got some co-workers using Acrobat in a long-handed way. They are going through these steps which will be repeated about 14,000 times:
1. Search one long pdf document for a name
2. Print the page
3. Repeat (14,000 times)
The search takes about 10 seconds (alone) on average - so it adds up to a bit of time, with all clicking and waiting for search results.
I'm not at all familiar with coding to Adobe's object model. Does anyone know if it's possible to automate these steps, given a list of names (they come in about 100 at at time in Excel, to be matched and printed). Naturally, the use of names will not be a perfect match so we'd probably need to print all matching names and sort out the duplicates (common names will likely have two or more matches).
Any ideas welcome. Cheers,
xenou