PDA

View Full Version : PDF to Excel Import



USAMax1
06-07-2013, 12:30 PM
I found a brielent code that does exactly what I want but I need to add it to existing code and change the input but one line fails everytime when I copy the code and user form into my workbook. This is the line that fails:


Dim AC_PD As Acrobat.AcroPDDoc 'access pdf file


The message I get is, "Compile error: User-defined type not defined"

Same code works in the downloaded workbook but not when I copy the code. I need to remove the userform and use the file and path from an existing worksheet.:banghead:

Kenneth Hobs
06-07-2013, 03:43 PM
Set the reference to Adobe Acrobat in Tools > References. Obviously, you need Acrobat, not the reader installed to have access to that object.