+ Reply to Thread
Results 1 to 4 of 4

VBA able to address named fields in a pdf?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    594

    VBA able to address named fields in a pdf?

    Hello!

    It seems to me that if one knows the name of a pdf document and if there are labeled fields within that document, somehow it should be possible to post data direct from Excel to the pdf named fields.

    I see a number of means with "helper applications", but no direct solution other than cumbersome sending keystrokes, which then also requires that you have the pdf open AND have verified the sequencing of the fields.

    I have considered making a pdf into something like a bmp and importing it as the picture background of a form, then posting fields where data is placed, but then one has to adapt the form to be able to print out a meaningful sheet/pdf from the form and given all of that, it would seem a lot simpler if fields in the pdf could be addressed directly, and should be somehow possible.

    Am i wrong?

    Thanks for your knowledge and thoughts!

    -Bruce

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,797

    Re: VBA able to address named fields in a pdf?

    I am not sure what you mean by "labeled fields", I've never used that in a PDF. But generally, those are internal features that are available to VBA if you have Adobe Acrobat Professional, which has a VBA callable library. The other option would be to write custom code to parse the code in the PDF file. I think the standard is published, but it seems like it would be a lot of work.

    If you open the PDF file in Word, are the labeled fields preserved? It is much easier for VBA to read a Word document.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    594

    Re: VBA able to address named fields in a pdf?

    In Acrobat Pro one can create a fillable form. To make it fillable, one places fields, and as in Excel, each of those fields can be named. It seems to me that there should be some sort of bridge that vba would be able to employ, certainly not as simple as "AddressForm.pdf:field:StreetAddress" = "123 Happy Street" because that would be wayyyyyy too easy and convenient for everyone, but somehow get to that-

    Oh - greetings from 50 miles south of you-

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,797

    Re: VBA able to address named fields in a pdf?

    If you have Acrobat Pro, then you should have a reference in your VBA Tools menu that you can activate. The question is what are the API calls you have to make to retrieve the field labels. I am not familiar with that API. I have an old version of Acrobat Pro, let me see if I can find anything out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding row to a named range-updating the named range address
    By kjsconv in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-12-2013, 11:22 PM
  2. [SOLVED] Use address of named range to find same address in another worksheet
    By dwsteyl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2013, 04:56 PM
  3. [SOLVED] Determine what Named Range the Target Address is and return Named Range Name
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2012, 10:49 PM
  4. Macro - address fields from Excel
    By BongoBill in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2010, 07:06 AM
  5. Seperate address fields
    By gmoney10111 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-26-2007, 05:01 AM
  6. Address is in separate fields
    By Jen96 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-14-2005, 09:55 AM
  7. Ranges of Named Fields
    By affordsol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2005, 12:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1