Skip to main content
C
canadaussie12
Participant
March 4, 2017
Answered

I am looking to retrieve PDF form data into Excel

  • March 4, 2017
  • 1 reply
  • 6207 views

I have coded Excel macros for years.  And I am looking to find a way to retrieve PDF form fields into Excel worksheets.  I haven't bought Acrobat Pro yet (I have seen that I must have PRO to do this) but I am wanting to get a good idea about the coding or methods before I buy...making sure I am not biting off more than I can chew

This topic has been closed for replies.
Correct answer Karl Heinz Kremer

Take a look here for an introduction: Reading PDF Form Fields with VBA - KHKonsulting LLC

You don't need Acrobat Pro, this will also work with Standard. The free Adobe Reader however is not sufficient.

1 reply

Karl Heinz Kremer
Community Expert
Karl Heinz KremerCommunity ExpertCorrect answer
Community Expert
March 4, 2017

Take a look here for an introduction: Reading PDF Form Fields with VBA - KHKonsulting LLC

You don't need Acrobat Pro, this will also work with Standard. The free Adobe Reader however is not sufficient.

C
canadaussie12Author
Participant
March 5, 2017

Karl,

Thank you for the reply.

I remember reading your link originally (it actually gave me the bug to think I could do it). However, I must not have had the reference to Acrobat clicked in Excel or I just got confused with the other information I read regarding needing Acrobat Pro.

I took your code, modified it slightly to matched the location of my PDF and a few fields inside that form, and it worked!

You made it seem simple and it was simple. So thank you!

I have tried to follow the instructions about clicking ‘Correct below the answer’ if the answer is indeed correct…but there is no ‘Correct’ to select.

Karl Heinz Kremer
Community Expert
Karl Heinz KremerCommunity Expert
Community Expert
March 6, 2017

Glad that I could help. It does look like you've already selected my answer as correct (you can see that when you look at your original question.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices