Excel to PDF(Select Fields) Data Transfer using a Macro?

[vaseline3194]

Hi everyone,


I have some information in an Excel document.

It has things like address, phone numbers, numerical values, etc and it corresponds to fields on a preset PDF document. This PDF document has fillable fields.

Instead of manually enterring information from the Excel to PDF, if it possible to create a MACRO using<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym> code to automatically populate the PDF document fillable fields?

If so, I was wondering if anyone knew how to do it?

I know I'd have to use Application Programming Interface but I don't know how to do the programming. I want to be able to learn as I go. Can someone help me out on how I would start?
http://www.adobe.com/content/dam/Adobe/en/devnet/acrobat/pdfs/iac_api_reference.pdf

I believe the above link shows adobe PDFs api referencing.



Is there a way to make excel communicate with the Adobe PDF program. Would it have to do with <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym>and XML?

And, does anyone know a good site to learn <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help;">VBA</acronym>/Macros with Excel....
I'm really interested in learning this, and potentially making life easier at work.

Thanks,

 

[mohsin002]

You might want to check this out:

Read And Write PDF Forms From Excel (VBA) ~ My Engineering World

This will let you create/enter data into a fillable PDF and even read it back so you can import it back into excel. One catch though: you will need Adobe Acrobat. I believe you should already have that since you are creating PDFs. Adobe Reader can only read PDFs and save filled PDFs if the PDF is allowed to do so.

And to learn VBA/Macros buy this book: Excel 2010 Power Programming with VBA (Mr. Spreadsheet's Bookshelf): John Walkenbach: 9780470475355: Amazon.com: Books

Hope this helps. let me know if you have any other questions.