These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Edit Text Fields in PDF Document

royalcorona
Registered: Mar 11 2010
Posts: 4

Hi,

I'm not sure if this is the appropriate place to raise this question?

I have a PDF document that has various entry text fields for the user to enter. What I would like to know is is there a way where I can enter text in Microsoft Excel then use a macro and send the text to the relevant fields in the PDF document text boxes.

Note, this PDF document is sent from a bank it is not created from me it is on the PDF document with text and text boxes. Just wonder in this case if it is impossible to do?

Thanks!!

My Product Information:
Acrobat Standard 9.2, Windows
jimhealy
Team
Registered: Jan 2 2006
Posts: 146
For most fields you could generate an FDF or XFDF and then launch it through a shellexec. You would then need to save the launched, resulting PDF with Acrobat standard or pro.
Alternatively, you could use Automation to run Javascript in the PDF from Excel and have a priviledged javascript to automate the save.

Jim Healy
FormRouter, Inc.
Check out our FREE Advanced Acroform Toolset:
http://www.formrouter.com/tools

Jim Healy, Founder & CEO FormRouter Inc.
Chapter Leader AUG RTP NC
http://www.formrouter.com

royalcorona
Registered: Mar 11 2010
Posts: 4
Jim,

Thanks for the reply. Are there any simpler methods? Perhaps not? Given the manner in what I am looking to do. I am not 100% literate in the Java script world. Anyway through VBA where I can like access the Adobe object and send the text to the fields from Excel cell references or ranges? Probably sounds a bit outrageous or impossible to do?

I only have the free download of the Adobe Reader so pretty limited there at the moment.

Any examples, should you have any, would be great.

Thanks!!
gkaiseril
Expert
Registered: Feb 23 2006
Posts: 4308
"Reader" is the operative word for the product, no commenting, no saving, no emailing, and no exporting unless special privileges are granted by the creator.

With version 9 Standard or one of the Professional variations or better, you can add fields, scripts
and special rights to perform certain functions. With a version 9 Standard or the Professional versions, one can add scripts to import/export to the FDF or XFDF file type or add a script to import/export to a tab delimited text file but there will be certain security restrictions that will require special files to be add to all users system. You could even create a new menu item or tool bar button to perform the imports and exports with Reader. More information is contained in the Acrobat JavaScript API Reference for the import/export as FDF, XFDF, and Text, the security restrictions, writing privileged functions, and adding menu and tool bar items.

George Kaiser

jimhealy
Team
Registered: Jan 2 2006
Posts: 146
You will not be able to do anything that will permanently affect the PDFs without at least Acrobat standard or some 3rd party library.

Jim Healy
FormRouter, Inc.
Check out our FREE Advanced Acroform Toolset:
http://www.formrouter.com/tools

Jim Healy, Founder & CEO FormRouter Inc.
Chapter Leader AUG RTP NC
http://www.formrouter.com