Insert a text box in PDF and fill data from Excel using VBA

[Ameena K]

Hey guys,

I want to use VBA to insert a single text box at the end of each page in a pdf file using the data from Excel worksheet. Please help.

 

[John_w]

This can be done with VBA and the Acrobat API, which is only available if Acrobat Pro (not the free Adobe Reader) is installed.

 

[Ameena K]

This can be done with VBA and the Acrobat API, which is only available if Acrobat Pro (not the free Adobe Reader) is installed.

Thank you for your reply. Does the version matter? Also, do I have to use Acrobat Javascript Reference?

 

[John_w]

The version of Acrobat Pro shouldn't matter and an Acrobat reference isn't needed, as the code can late bind to the Acrobat library objects.

 

[Ameena K]

The version of Acrobat Pro shouldn't matter and an Acrobat reference isn't needed, as the code can late bind to the Acrobat library objects.

Could you please demonstrate a simple example to insert a text box at a particular part of the page? I am not able to do it without JavaScript reference.

 

[John_w]

Which JavaScript reference are you talking about? I've never used any JavaScript reference for manipulating PDFs. The only one I've used, and only if early binding, is Adobe Acrobat Type Library.

This code adds a text box on every page:

Adobe PDF add page numbers

Hi, I am using this macro to merge two pdf:s. Each pdf have page numbers, and the merged file keeps the original page numbers. I want to make a new numbering for the whole new (merged) pdf. Any clues? Sub MergePdf() 'inspired by VBA A2Z youtube: Dim Aapp As Acrobat.AcroApp Dim PDF As...

www.mrexcel.com