VBA to fill out PDF Forms - VBA PDF Automation-6 

Thank you for such an useful tutorial! I was wondering if there would be anyway to declare and set the variables for the fields automatically. For example, would there be a way to do "Dim first_name as AFORMAUTLib.field" and "Set first_name = pdf_form.Fields("First Name_pp0X..." automatically? I was thinking maybe using an array of numbers to declare fields (such as Dim 1,2,3... as AFORMAUTLib.field) feature and some sort of a loop. Since you have the field names from the pdf on Sheet4, I feel like there could be away to do so. I'm ultimately asking this question because I have multiple pdfs with different fields names and a lot of fields to copy the data from Excel. So wondering if there is an easier way of doing so.

Thank you so much! This helped me solve a different case :) I owe you

Thank you very much Sir for sharing your wonderful work.

Great video. Thank you. Is there a way to programically get the radio button choices from a group of radio buttons?

Many thanks for the great work. I was wondering if you have any ideas about working with images in PDF files through vba? Much appreciated.

Please do one more video on how to fill a PDF forms using the data in excel. Thank you, this is very useful.

Is it possible to create a VBA Macro that takes information from the spreadsheet into a form online? Would love to see a video on that!

Is it possible to stamp on the pdf attachments using outlook macro ?

Great video

Hello, I have a question. Is it possible to fill in multiple seperate pdf forms from excel and make it apply to all the seperated pdf forms?

Excellent tutorial, works like a charm for me except for radio buttons and checkboxes. All the texts fields save just fine but the other field types will not. What is even more strange is that I can halt the code BEFORE it saves and SEE my changes, but as soon as I close the form - doesn't matter what I do, Save, Save As, Save As Other - it fields revert back to the original values. Any ideas?

Very helpful. Can the code work without Adobe Acrobat Pro? Because my current target pdf form only allows users to use Acrobat Reader 32x bit to open the pdf. If we use Adobe Acrobat Pro, it will give warnings to the users when we open it.

Do you have to Reference something or have something installed to be able to use this like an Adobe Library?

Thanks, this helped a lot. The code stops at the if statement for saving the file. Is there another way to save an open pdf?

Can I do similar thing in either VB.NET or C#.NET?

Does it autofill check box?

Hi i have a problem with AFORMAUTLib...it's not defined by user Why ? please help. It's possible that is not in the system....whare i can found it?

is it Possible To insert img sous form PDF en Autofill Form ? you know what i mean ?

Is that possible to print form without pdf form ( as normal pdf file)

This worked perfectly for weeks and then suddenly it had stopped recently even though I didn't change anything. Now I'm getting this automation error saying element not found with a run-time error -2147319765 (8002802b), do you know what the issue is? I had kept everything the same when it decided not to work anymore. It occurs when writing to PDF at Set first_name = pdf_form.Fields("the field name")

Thank you so much How can I add an image to the image field in a PDF using vba?

Does not work. There is no instruction on what reference library you used in this tutorial. Go "Compile-Error: User-defined Type not defined" at "Dim pdf_form As AFormAutLib.AFormApp". Seems like your method does not work with Adobe Acrobat 10.0 Type Library which I'm using. Other examples I found online use "Dim pdfApp As *Acrobat.CAcroApp*" instead of "Dim pdfApp As *Acrobat.AcroApp*". What's the difference? Actually I'm stuck at pdfDoc.Save(PDSaveFull, "C:\VBA\Test.pdf"). No idea why it's not saving.

:-( so you create the pdf within Excel and not use existing pdf to fill in form fields.