I have Excel 2010 and Adobe Acrobat 10 Professional. I am using the VBA code below to extract pages from a PDF based on keywords that are present on the page (if keyword present, then page is extracted).
However, I am looking for a simpler approach of extracting pages based on page number (page numbers will be listed in column A). Any ideas on how to modify the script below to accomplish this? Thanks.
Please Login or Register to view this content.
I wrote somethign similar a while back, it looked at generated reports from Hyperion in PDF format, and stitched the relevant pages together in 1 report. It was an absolute nightmare, i did it with the Adobe Class in C#, there is a way to reference a page, i'll take a look and checK.
From what i can see, you'll need to loop through a and modify your code
somthing like
Please Login or Register to view this content.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
hi Brawnystaff, please check attachment, press "Start" button, the code is in Module 2
Thanks Watersev..worked perfectly!!
That is sweet code! I was looking for this for at least a week. Im trying to input comments or highlight certain text strings in the output pages. Do you have any idea how to do that?
Thanks!
Jaime
hi Jaime, as per Forum Rules:
2. Don't post a question in the thread of another member -- start your own...
hi watersev, this is great. thank you! may i check with you, is it possible to do it in multiple pdf file at the same time? given that the extracted pages are all same.? hoping for your immediate response. thank you
Perhaps you missed waterserv's comment in post 6?Originally Posted by kontessacm
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks