Find Invoice Number in PDF

[Sarry]

Hi, Been watching and reading posts here for some time, and am never quick enough to help. But now i have my own problem. I have harvested some excellent code from the net to find the text "Invoice No:" on a PDF and verify it is found. however I cannot find get only the number next to it. This problem is repeated for "consignment no:" and "order no:" which i would also like to extract.

 

[John_w]

How are you searching for the text? The Acrobat API method FindText verifies that a string exists in the document, however you need to use the GetText method in a loop to read all the document text into an array or string and then you can search the array or string for "Invoice No:" and get the number near it. The thread below shows this method:

Excel VBA for Adobe Acrobat page extraction based on keyword

I have Excel 2010 and Adobe Professional 10. I currently am using the VBA code to extract pages to a separate PDF that have a matching numeric value in them (based on numeric values in Column A). I am trying to modify it so that I can use regular keywords to extract pages with content in it...

www.mrexcel.com

 

[Sarry]

Hi John_w, that was extremely helpful thank you, from the complete compiled pdf text i was able to find and extract the data I needed. when I have finessed the code some more I will post it here.