Vba pdf form fields

I'm not fully sure what I'm doing as I'm still learning all this stuff, but below is what I've put together so far. I've marked where excel errors out at.

The error message I get is this: "FieldList Error: 91 Object variable or With block variable not set VBAProject" I'm not entirely sure what it means however, could someone point out what I need to address to change this? Thank you Reason: Removing unncessary text. I see 3 problems, maybe. There are ways to just iterate PDF files. For now, you can try looking at the file extension. I'm not sure what you mean by a flattened file - is that where you print the pdf to make it uneditable, like a big picture?

Each of the two files are still editable Although they have been signed digitally. I first tested to see if I could pull the specific data fields with the following code, which worked like a charm: Code:. Yes, flattened means no text readable content.

For most cases, that will not be a problem. I stole, errrr have, a routine that sort of does what this macro does but iterates all pdf files in a folder and shows field information in a worksheet. Here is some code that you have probably seen. The field names are displayed in a text box contained in the application's form. The ''' form fields identified can be used to map each of the ''' fields in a PDF. Fields sb. Append de. NewLine Next ' Write the string builder's content to the form's textbox textBox1.

ToString textBox1. In order to map these fields to specific fields in the PDF, one need only copy this list and pass values to each of the fields to identify them. For example, if the form contains ten fields, setting the value shown next to a sequential number will result in the display of the numbers 1 to 10 in each of the fields. One can then track that field value back to the field name using this list as the basis for the map. Once the fields have been identified, the application can be written to pass the correct values to the related field.

Checkbox controls may be a little more challenging to figure out. I tried passing several values to the checkbox controls before lining up a winner. In this example, I tried pass zero, one, true, false, etc. The next section of code in the demo project is used to fill in the mapped field values. The process is simple enough, the first thing that happens is that that the template file and new file locations are defined and passed to string variables.

Once the paths are defined, the code creates an instance of the PDF reader which is used to read the template file, and a PDF stamper which is used to fill in the form fields in the new file. Once the template and target files are set up, the last thing to do is to create an instance of the AcroFields which is populated with all of the fields contained in the target PDF.

Will need to play with it for a bit. But, I understand what were doing here sorta , but thanks for the info. Much appreciated!!!! You must log in or register to reply here. Similar threads T. Replies 1 Views Saturday at AM tjdickinson. Replies 5 Views Sunday at AM tjdickinson. Replies 0 Views Question How to export excel sheet with high fidelity images as pdf and retain image quality, using VBA. Replies 2 Views Ameena K Apr 8, Excel Questions.

Replies 5 Views 1K. Understanding data is crucial, and the easiest place to start is with Microsoft Excel. Forum statistics Threads 1,, Messages 5,, Members , Latest member maandren. We've detected that you are using an adblocker. We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel. Close AcroApp. The only new command introduced is the getField function, which returns a form field. Give it a try and let me know how it works for you.

Also, this program will not work with XFA forms the ones you create in Designer. This is exactly what I am looking for. Thanks so much. However, my assignments are a bit different. I am wondering if you can give me a hand. The data source: 1. An excel spreadsheet storing the raw data 2. A PDF file with an interactive form used to store the data input by the user according to the above excel spreadsheet.

My assignments: 1. I am not allowed to convert the Excel spreadsheet to the PDF file directly as the PDF file is the template with precise paragraphing and wording embedded. It is a heavy job when there are over hundreds of number. I am thinking if the excel VBA can do both assignments automatically or at least double check my input. September 25th, at pm permalink. September 27th, at am permalink. I am having the same problem as Wayne, but cannot find the solution.

Error Object Required at —. February 16th, at pm permalink. It works fine on my PC. Look forward to a solution for distribution. October 5th, at pm permalink. Leif, do you have Adobe Acrobat installed on the second machine? Based on the error message, I assume that you are trying to run your application on a system without Acrobat. Thanks for your prompt response.

I have Adobe Reader 9 on the other PC. Is it necessary to also have Acrobat 9 pro installed? If so, is there another way to distribute without have Acrobat pro installed on target PC? October 6th, at am permalink. Thank You for prompt answer. The target PC have Adobe Reader 9.