PDA

View Full Version : Read pdf content from excel



rajagopal
06-13-2013, 03:07 AM
Is there's any way to read a pdf file from excel. The PDF file consists of multiple pages and in editable format. The macro has to read the content present in the tables and I would like to copy them to excel? Is this possible through VBA.

Thanks

lotuxel
06-19-2013, 01:12 AM
Hi,
In according our experience we save the pdf file as text file and read with excel vba and fill in excel sheet....

Jan Karel Pieterse
06-19-2013, 05:21 AM
Depends. Word 2013 can import PDFs natively so you could automate Word from Excel. If you do not have Office 2013 you will need some third party tool that can convert pdf's to Office.

lotuxel
06-19-2013, 06:59 PM
Thanks for the great information.