Skip navigation

Acrobat SDK

gapsys Calculating status...

Currently Being Moderated

Need help with VBA to control PDF fields

May 11, 2011 2:20 PM

Hi,

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

Open a template PDF document
Populate the LastName, First Name fields
Then lock (make fields ReadOnly) the above so the User cannot modify them
Then save the PDF with the prefixed Lastname & First Name.

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.

Thanks

1331 Views 2 Replies Latest reply: gapsys, May 12, 2011 2:02 PM

Replies

9,232 posts
Aug 11, 2002

Currently Being Moderated

1. George Johnson,

May 11, 2011 7:10 PM in reply to gapsys

Report

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.

|
Mark as:
Currently Being Moderated

2. gapsys,

May 12, 2011 2:02 PM in reply to George Johnson

Report

George,
Thanks once again for this link - I will try it after I solve the other issue that you answered re "Populate a text field with contents from a file?" in the Acrobat Windows forum.

Thanks

|
Mark as:

Forum guidelines

Answers + Points = Status

10 points awarded for Correct Answers
5 points awarded for Helpful Answers
10,000+ points
1,001-10,000 points
501-1,000 points
5-500 points