Read\Write to PDF Files using Microsoft Excel VBA Programming

This video shows how to programatically read\write to a PDF file using Microsoft Excel 2010/2007 using PDF API. Using Excel, you can read\write to PDF fields and other controls.

Note: Remember to add your Adobe Acrobat Library in the VB Environment. Tools, References, Select the Adobe Acrobat Library. This does require Adobe Pro*

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

[A]

This is exactly the level of explanation I like, this video is great! Thanks!

[noahjulianramseur]

Does not work. Keep getting Compile error: Variable not defined. Running excel 2016 on Windows 10.

[jmtiwari]

This is exactly what i was looking for.

[raymonddarazi]

Hello Alex, Thank you so much for this great video / tutorial. It works great but still missing the SAVE. Kindly let us know how to save the PDF file. Thank you, Raymond Darazi

[JoeCoolCols]

Nevermind about the question see now you have to regiseter with adobe to down load the SDK

[rootbeer]

thank you Alex for sharing your knowledge soooo useful.

hugo from québec.

[agricambo]

Hi Alex, May I get the code in the Module, please?

[rsmaster]

Hello! Very Nice Function... There is only one Problem.. When Writing to the PDF, the PDF Programm Dont Closes at the End of Writing Data To it..
First i found a Problem That it Stucks on the Save As Promt. After Solving the File Save Issue the PDF Program Stays Open and i have to shut down Manualy ...
The .Exit Function does Has Anyone the Same Problem or Found a Solution ?

[domzkyofficial]

Can i copy your code..for easy edit on macros.

[JoeCoolCols]

Never mind see now that you have to register with adobe to download the sdk.

[paulwilson-mymf]

Hi Alex,
Thank you so much for this tutorial, I was trying to do this with sendkeys without too much success.
I have AdobePro is there a way to SaveAs the file which I have just updated? I have numerous sheets which work off of the same base template pdf document and the saveas ability would be the answer.
Thanks again for this explanation.

[JoeCoolCols]

Ok, found out the problem was moving it to another directory even though I copied the SDK File to the same directory

[jamisonrobert]

I can't seem to get this to work with Acrobat DC and Excel 2016. When I run "Dim AcrobatApplication As Acrobat.CAcroApp" I get a message "User-defined type not defined." Any ideas?

[JoeCoolCols]

Sorry for mutiple comments.could you show or describe how to add a reference ? Thanks, Joe

[JoeCoolCols]

Could you show how to set this up in a video?

Thanks, Joe

[tonysparapani]

I like your code and i think i would have a use for it, however i tried to use it and it wont work with my 2016 excel. Is there an adaptation that you could share?

[premkumarramanathan]

Hi Alex, can you please help me out with the specific problem I'm facing.

[marymadyarova]

Alex, Do you know how to get and change coordinates of a specific text (Ex. "Figure 1" in the right coner) on a PDF page. PDF page has only text. I am writing VBA code and cannot figure it out.

[pliniomsann]

Nice Alex ...  with this code can you also read tables inside the pdf doc?
Thank you in advance

[islahiyette]

hi i want write a specific watermark to each pdf page in vba i habe 500 pages