Opening PDF with Adobe Reader 9

**amoxia** · 12-18-2013, 10:13 PM

Hi all,

I have the below code working perfectly with my adobe pro.. however I created it for someone who has adobe reader 9 only. It opens up a pdf saves it as text file then imports that into excel then moves onto the next pdf.

I am getting a run time error 429 - ActiveX component can't create object - at the line

Set AcroXApp = CreateObject("AcroExch.App")
AcroXApp.Hide
Set AcroXAVDoc = CreateObject("AcroExch.AVDoc")

Any suggestions??

Thanks

Please Login or Register  to view this content.

**shg** · 12-18-2013, 10:40 PM

They're going to need to buy Acrobat. Reader doesn't have the ability to export to text (or anything else).

**amoxia** · 12-18-2013, 11:36 PM

shg - when I open reader I can still save as a text file, which is what I am doing in the code above. My question is how do I open reader with a macro.

Cheers,
amoxia

**shg** · 12-19-2013, 02:01 AM

No, you're opening the file in Acrobat, which also provides the COM library that you're using in your code.

Adobe Reader can't save in any other format than pdf.