I have 3 "forms" all created in Excel 2011 for Mac and converted to PDF using the 'print to PDF' option and then within Acrobat create the fillable form. Each form has 143 fields for user input and selection. The forms are downloaded from a web site, and completed in the majority of cases by customers with little PC / web expertise.
I now need to make some changes to the forms, and it appears that the only way AFAIK is to make the changes in Excel and then reconvert the file and again go through the long process of creating all the fields. When I attempt to get Adobe to use the OCR in order to make the change directly in Acrobat, it complains bitterly advising that the text is not editable.
The reason for the 3 different forms, is that the data displayed is only slightly different depending on the initial option selected, but as I do not know how to perform this selection in Acrobat, I created 3 separate forms, naming these according to the first option.
If the displaying options could be achieved within Acrobat, as can be done in Excel, using conditional formatting and VBA to control the relevant sections / lines of the document being shown, I would at least only have to recreate the form once. Unfortunately, my knowledge of Adobe Acrobat Pro 9 is limited to creating the fields and saving the forms.
Alternatively, is it possible to create the fields in Excel and have these carried across into the PDF form?
I know the above is a mouthful, but any feedback would be appreciated
I now need to make some changes to the forms, and it appears that the only way AFAIK is to make the changes in Excel and then reconvert the file and again go through the long process of creating all the fields. When I attempt to get Adobe to use the OCR in order to make the change directly in Acrobat, it complains bitterly advising that the text is not editable.
The reason for the 3 different forms, is that the data displayed is only slightly different depending on the initial option selected, but as I do not know how to perform this selection in Acrobat, I created 3 separate forms, naming these according to the first option.
If the displaying options could be achieved within Acrobat, as can be done in Excel, using conditional formatting and VBA to control the relevant sections / lines of the document being shown, I would at least only have to recreate the form once. Unfortunately, my knowledge of Adobe Acrobat Pro 9 is limited to creating the fields and saving the forms.
Alternatively, is it possible to create the fields in Excel and have these carried across into the PDF form?
I know the above is a mouthful, but any feedback would be appreciated
