Paul's right that it's harder to figure out someone else's thinking than to look through your own code; you know, after all, how you think, and you already know your own goal. But I don't see any way around it; show me what you've been trying, and I'll see what I can make of it. We're talking about only part 2, at this point.

I expect the general idea must be something like this: 1) Run Adobe 8 Professional. 2) In Adobe, read the .pdf file. 3) Use Adobe's Save-As feature to save the file in another format, .txt or .csv or whatever works best. 4) Quit Adobe. That's what a human would do; but the question is how to get VBA to tell Adobe to do all that? If there's an Adobe COM object, and we can find it—and the documentation for it—then it should be easy. If not, well, there are workarounds that might work. But I'm much rather find an Adobe object we can invoke from inside VBA.

So if you and Paul have found the Adobe object documentation, point me to that too, please, in addition to posting the workbook with your VBA code in it.