Si Ball
asked on
excel VBA to read fields from an adobe pdf form
Hello.
My friend has people sending him completed pdf forms. He has been typing in the form contents into a spreadsheet. I said it could probably be done with VBA... should have looked around first...
Found lots of stuff about using the Acrobat writer softwares DLL as a reference in VBA in order to write data into a form from excel, but i don;t have writer software, and i'd like to import the fields data.
i can manage vba to browse for pdf file and get filename and path.. and i read that a pdf is only a tar'd xml file...
does anyone know a quick / easy / free (delete as appropriate) method for importing the data from a pdf form into excel.
cheers
Sudo.
My friend has people sending him completed pdf forms. He has been typing in the form contents into a spreadsheet. I said it could probably be done with VBA... should have looked around first...
Found lots of stuff about using the Acrobat writer softwares DLL as a reference in VBA in order to write data into a form from excel, but i don;t have writer software, and i'd like to import the fields data.
i can manage vba to browse for pdf file and get filename and path.. and i read that a pdf is only a tar'd xml file...
does anyone know a quick / easy / free (delete as appropriate) method for importing the data from a pdf form into excel.
cheers
Sudo.
Is it not available in your > Tools > References > Acrobat ?
HTH,
Daniel
HTH,
Daniel
Also you need to have the Full version of Acrobat to get this code work, with only the Reader version you cant.
HTH,
Daniel
HTH,
Daniel
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
i found this article :
https://www.experts-exchange.com/questions/26489233/PDF-Fields.html?sfQueryTermInfo=1+10+30+excel+form+pdf+vba
which calls this code:
Open in new window
but when i try and run it i get an error, presumably as i do not have acrobat as a reference..
Set gApp = CreateObject("AcroExch.App
Runtime Error 429
ActiveX component cannot create object