PDA

View Full Version : Populating PDF document with Excel vba



doubtfire
08-01-2017, 06:23 PM
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!:help

macropod
08-01-2017, 10:12 PM
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.

doubtfire
08-02-2017, 02:43 PM
Alright, thank you for the final answer regarding VBA/Adobe Reader.