Excel Hints

Results 1 to 4 of 4

Thread: Populate PDF Form via VBA

  1. #1

    Populate PDF Form via VBA

    Hello,

    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?

    Thanks

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

    VB:
     
    AcroApp = CreateObject("AcroExch.App") 
    AvDoc = CreateObject("AcroExch.AVDoc") 
    PDDoc = CreateObject("AcroExch.PDDoc") 
    If AvDoc.Open cPDF,"" Then 'pdf document is open
    
    
    Formatting tags added by mark007
    then to fill in form data, something like

    VB:
     
    AcroForm = CreateObject("AFormAut.App") 
    Fields = AcroForm.Fields 
    For Each f In Fields 
        If f.type="Text" Then Fields.Item(f).Value = "something" 
    Next f 
    
    
    Formatting tags added by mark007
    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.

    http://www.adobe.com/devnet/acrobat/fdftoolkit.html

Posting Permissions

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