Consulting

Results 1 to 3 of 3

Thread: Populating PDF document with Excel vba

  1. #1

    Populating PDF document with Excel vba

    I have received a PDF document from one of our customers (PDF fields listed from Acrobat) and I need to populate data from Excel sheet.
    Can I write a VBA program to populate those fields for the Sales department and they have Adobe Reader only (not everyone has the Acrobat) ?
    Any suggestions and examples are welcome!

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    The Adobe Reader can't be automated via VBA. You may be able to use PDF JavaScript in the actual PDFs to import the data after setting up some appropriate folder level permissions, but do be aware that PDF JavaScript is a common vector for spreading malicious JavaScript code.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Alright, thank you for the final answer regarding VBA/Adobe Reader.

Posting Permissions

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