joshcallahan1
asked on
Acrobat Professional Delete pages based on Excel File
Hi,
I have a 2,000 page PDF and I have adobe professional. I need to delete pages out of this file if they contain a number which is found in an MS Excel file.
The MS excel file is 2003 format. It contins a list of numbers. Any page in the PDF file with one of these numbers needs to be deleted.
I'm Guessing this is only possible with Javascript which I am mildly familiar with, so I have no idea how to do this.
Thanks for your help.
Josh
I have a 2,000 page PDF and I have adobe professional. I need to delete pages out of this file if they contain a number which is found in an MS Excel file.
The MS excel file is 2003 format. It contins a list of numbers. Any page in the PDF file with one of these numbers needs to be deleted.
I'm Guessing this is only possible with Javascript which I am mildly familiar with, so I have no idea how to do this.
Thanks for your help.
Josh
ASKER
Not quite what I mean. I think there may be several ways to accomplish this.
-Print the excel sheet (which is a list of numbers) into pdf and use it to create an index to the pages. I don't know how to do that.
-I think then it would be possible to delete all pages with bookmark desinations on them.
I'm not sure how to do it but this would be my best guess. If someone could send me some javascript for this it would be great.
Or send another Idea on how to solve this one. Thansk =)
-Print the excel sheet (which is a list of numbers) into pdf and use it to create an index to the pages. I don't know how to do that.
-I think then it would be possible to delete all pages with bookmark desinations on them.
I'm not sure how to do it but this would be my best guess. If someone could send me some javascript for this it would be great.
Or send another Idea on how to solve this one. Thansk =)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow!! just ran this as a macro out of Excel after changing the source PDF files and it worked on the first try. Best answer I've gotten on EE so far. Thanks!!
Thanks, joshcallahan1, glad to help!
ASKER
Oh I forgot to mention that in the VBA editor for the Excel file I had to go to Tools>References> and I clicked on the the various Adobe options, it won't work without that.
Thanks, joshcallahan1. I'd cryptically mentioned that (You'll need to change the Adobe reference), but your post is much clearer for anyone coming across this.
http://commonsenseatheism.com/?p=8335