MACROs:Is it possible to Data Transfer between programs-> Excel and PDF?

[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 VBA 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 VBA and XML?

And, does anyone know a good site to learn VBA/Macros with Excel....
I'm really interested in learning this, and potentially making life easier at work.

Thanks,

 

[BrianB]

This would be a big project starting from nothing.
Method 1
I would first consider making a facsimile copy of the PDF file in an Excel worksheet when cells can be filled in as required. You could then save the worksheet as a PDF. I wouldn't think anyone would know the difference.

Method 2
When I open VB Editor Tools/References in Excel 2010 I see that I already have :-
Adobe Access 3.0 Type Library
Adobe Access 10.0 Type Library
Adobe Reader File Preview Type Library
So it looks like it is possible to manipulate PDF files directly.
Having ticked the boxes to add the libraries to your project it is then possible to get more informtion about them from the Object Browser - and perhaps do some Google searches on the terms there (they will probably be unique).

Method 3
Any file can be opened using the Open method as for a text file. It may be possible to fill in a template form with unique entries, open it, and do a find/replace using Regular Expression. Here is an example of using this method to get the last user of an Excel Workbook (if I open the workbook in the usual way I immediately become the last user). ... Mr.Excel link to message
VBA function to get username of open file on network?