Third party apps are not an option (I'm restricted from installing anything on my office PC).

I could simply save each PDF manually, but given the number of files this would not be practical.

The text it will output does not have to be pretty by any means (and I'm aware it won't be).

As long as I can get the PDF files in a text file format, there would be no further obstacles for me - because I would then be able to get Excel to gather-import all the data and consolidate-clean-organize everything accordingly at that point.

Have you referenced the adobe/acrobat type library in the VBA editor? (Tools -->References -----> Whichever type library references all that PDF junk) I can't remember which type library it is...maybe AcroBrokerLib or maybe it's just Acrobat. Either way, if you're not referencing it in your code, then your VB code doesn't know what to do with it. First, I'd say try referencing the Adobe Acrobat 8.0 Type Library....

one other thought is that you can create text files with a batch process inside of acrobat. Advanced ---> Document Processing ----> Batch Processing.

Choose new sequence, give it a name

Step 1: Select Commands ----> Choose "execute javascript", then hit "Add." Click on "Execute Javascript" that was just added on the right, then hit the edit button and toss in the script below that I grabbed from the javascript samples (also, if your docs have multiple pages you'll need to embed the for loop into another for loop that cycles through each page). You'd also want to change the name of the saved txt file to the name of pdf you're doing it to. It shouldn't be that hard, but I'm guessing you're probably alot more familiar with VBA then javascript which is why you're choosing to do it from excel. I'm kind of in the same boat of having written a bunch of VBA, but not much javascript. I highly recommend investing some time into learning acrobat scripting b/c VB does have it's limitations when it comes to messing with PDF's.

/**

*function to extract the text content of the current page and save to a file.