• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert data from PDF to Excel.

Jagdev Singh

Active Member
Hi Experts

I am looking for converting data from PDF to Excel..Could you please help me with the VBA code to create a macro which will pick pdf files from the specific folder/location and convert its data into excel.

I have Adobe Reader XI installed in my machine..

Thanks in advance.

Regards,
Jaggi
 
Hi Ashish

I tried this code but it is throwing an error of object not found..Please find the sample macro attached..

Regards,
Jaggi
 

Attachments

  • Sample.xlsm
    23.3 KB · Views: 5
Hi Jagdev - These codes just convert the file extention from pdf to xls...looks like it wont help you..
 
Hi Ashish

I need the information in the PDF to be converted to Excel. I am not sure this code is of use of not, but it is not working in my case. I even changed the reference tool to the one explained on the site, but still it is not working.

Regards,
Jaggi
 
Hi Narayan

Thanks for sharing the above link. It is good to know that we have so many inbuilt functionality avaialble in Adode..But I am not that fortunate about it. We are using the normal version of Adobe reader XI..The conversion facility is available on the above verion i.e. Adobe acrobat standard and Adobe acrobat professional.

Please refer the above link for more detail - http://www.adobe.com/in/products/acrobat/product-comparison.html

Regards,
JD
 
Hi Narayan

Sorry for missing out those words. It will be a temp solution. I am looking for a long term solution.

Regards
JD
 
Back
Top