Link to home
Start Free TrialLog in
Avatar of joshcallahan1
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
Avatar of whosbetterthanme
whosbetterthanme
Flag of United States of America image

This article can help you:

http://commonsenseatheism.com/?p=8335
Avatar of joshcallahan1
joshcallahan1

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 =)
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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!
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.