The Amsterdam Excel Summit

Results 1 to 4 of 4

Thread: Populate PDF Form via VBA

  1. #1

    Populate PDF Form via VBA


    I have created a PDF form via Adobe Acrobat Pro 8.0. Please is there any solution to populate the text fields in the Adobe form via VBA?


  2. #2
    I have 7.0, but assuming your VBA code does something like (where cPDF is your document)

    AcroApp = CreateObject("AcroExch.App")
    AvDoc = CreateObject("AcroExch.AVDoc")
    PDDoc = CreateObject("AcroExch.PDDoc")
    If AvDoc.Open cPDF,"" Then 'pdf document is open

    then to fill in form data, something like

    AcroForm = CreateObject("AFormAut.App")
    Fields = AcroForm.Fields
    For Each f in Fields
    If f.type="Text" Then Fields.Item(f).Value = "something"
    Next f

    If your form has radio buttons, other types of controls or you need fields marked as readonly after data is entered, it gets more complicated, so you might want to post a copy of the pdf. .02 Stan

  3. #3
    Thanks very much, I tried the instructions that you have provided and it is perfect, the data are easily transmitted from access table to PDF form in no time.

  4. #4
    Also look into using fdf data files, they can make life MUCH easier for complicated PDF forms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts