Professional Web Applications Themes

Adobe Acrobat 6 Professional: Excel data to PDF Forms - Adobe Acrobat Windows

Is it possible to enter data on Excel (text1, text2, etc)and transfer automatically to PDF form (Acrobat 6 Professional)?...

  1. #1

    Default Adobe Acrobat 6 Professional: Excel data to PDF Forms

    Is it possible to enter data on Excel (text1, text2, etc)and transfer automatically to PDF form (Acrobat 6 Professional)?
    Donald_E_Drummond@adobeforums.com Guest

  2. #2

    Default Re: Adobe Acrobat 6 Professional: Excel data to PDF Forms

    Define what you mean by 'automatically'
    MarkATS@adobeforums.com Guest

  3. #3

    Default Re: Adobe Acrobat 6 Professional: Excel data to PDF Forms

    No problem creating Fill-in forms with Acrobat 6 Professional. I have to complete twelve copies of one PDF from (fill-in data), each month. Some of data is carried over from the previous month, some is new, and some repeated on some of the forms. Entering the data (fill-in forms), each month is time comsuming, and subject to error (human error). What I want to do: (Using Excel) enter the data block (text identification) on one one columm,enter the corresponding data in the second column, and transfer the data to the PDF form.
    Donald_E_Drummond@adobeforums.com Guest

  4. #4

    Default Re: Adobe Acrobat 6 Professional: Excel data to PDF Forms

    So, after you enter the data in Excel, print to Adobe PDF printer or use PDFMaker to make a new PDF, overwriting the old one.
    MarkATS@adobeforums.com Guest

  5. #5

    Default Re: Adobe Acrobat 6 Professional: Excel data to PDF Forms

    Donald,

    There are a number of ways to accomplish what you want. I would be likely to set up a VBA routine in Excel to create an FDF (Forms Data Format) file that contains the data from the spreadsheet. This FDF can then be manually or programmatically imported into the form with Acrobat.

    You can also set up the spreadsheet so that it exports the data in a tab-delimited format that Acrobat can import. The first row has to be the field names and subsequent rows would be the data, each row being a separate record. The resulting text file can be used to manually or programmatically (via Acrobat JavaScript) populate the PDF form.

    You can also use JavaScript in the PDF to get the data directly from the Excel file via ADBC. This is a bit more complicated to set up but has certain advantages.

    You can also create a VBScript (or use some other programming language, even VBA within Excel) to get the data from the Excel file and then communicate with Acrobat to populate the form. This too is more complicated but allows you to completely automate via an external process.

    If you'd like more information on any of these approaches, post again.

    George
    George_Johnson@adobeforums.com Guest

Similar Threads

  1. Adobe Acrobat 8.1.0 Professional
    By Lewis_Harman@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: January 22nd, 08:00 AM
  2. Adobe Acrobat 7.0 Professional won't open
    By Bruce_Selyem@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 5
    Last Post: December 13th, 11:28 PM
  3. Acrobat Professional: Can't create forms?
    By George Krompacky in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: September 8th, 06:27 PM
  4. Adobe Acrobat 6.0 Professional
    By Sharon Briscoe in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: September 3rd, 09:53 PM
  5. I can't install Adobe Acrobat Professional...
    By Johan_Gustavsson@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 4
    Last Post: April 22nd, 07:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139