I am attempting to use Excel VBA to control Acrobat but cannot find any documentation on the syntax to modify fields within the PDF form.
I am able to commnicate with Acrobat using CreateObject ( "AcroExch.App") and point to the AVDocs, PDDocs, PDPage objects.
However, I cannot find any methods that would allow me to change fields on the PDF.
I am attempting something very similar to a mail merge where I
The template PDF form is created in LiveCycle Designer & is a fillable PDF. It can be filled in Adobe Reader.
Am using Office 2007 Excel with the corresponding VBA - The VB code has a Reference to Adobe Acrobat 9.0 Type library.
For an XFA document, try using the JSObject (http://livedocs.adobe.com/acrobat_sdk/9.1/Acrobat9_1_HTMLHelp/IAC_DevA pp_OLE_Support.100.13.html) to control the form. I haven't tried this, but I think it's your best chance for the second and third things you list.
Europe, Middle East and Africa