Paul-

I figured out what was wrong with the conversion script. It was trying to save it as plain text instead of accessible text. I fixed it by changing the code to read:

jsObj.SaveAs ThisWorkbook.Path & "\" & "ProductCatalog.txt", "com.adobe.acrobat.accesstext"

All three scripts now successfully run if you run them individually in order. The last step is to put all three of these scripts together into a single macro. There is a brief delay when downloading the file and also when converting the script since its a 800 page PDF file so I am not sure how this needs to be reflected when combining all three. Is this something you can help with?

Just a side note: I took "com.adobe.acrobat.access-text" to mean text that is in some way more useful to MS Access rather than is the regular text. I didn't have any idea what that was, and anyway you were trying to import it into Excel not Access, so I didn't mention it.

But if you happen to know that "...access-text" really does mean "accessible", let me know where you saw the definition. I was just assuming, but I'd much rather know. Someday it may matter.

I don't mean to keep rushing in ahead of Paul; I just see an issue and start talking. But if you'd rather Paul worked with you on melding the three pieces together into the final product, maybe I should send him a private message; if he's like me, maybe he sees someone else's name on the answers and assumes it's taken care of, without realizing you're asking for his help specifically.

Bob-

Thank you for your response to this message. If you do a File, Save As in Adobe Acrobat, the two text options are "Text (Accessible)(*.txt)" and "Text (Plain)(*.txt)"

I am willing to work with either one of you on putting the files together, but it does bring up a good point that finalizing this part of the project might be best to be handled in a private message or via email so that it is not readily available to the public. Let me know what works best for either of you. Thanks!

Paul, do you have a preference?

(You're right, Shane; it must mean "accessible". I just don't know how that differs from "plain". But if one worked for you and the other didn't, I'll file that away and maybe it'll save me trouble someday down the road. Thanks.)