Free for PREMIUM members
Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.
In order to achieve this we have to make a reference in the excel program to the Adobe Acrobat 6.0 Type Library ( acrobat tlb).
the Excel Macro code example ( in which a field, named P1.REP in the PDF document will be set to the value "test test test" ) ( this macro is triggered in the Excel tax calculation program )
Private Sub UpdatePDF()
Dim gApp As Acrobat.CAcroApp
Dim pdDoc As Acrobat.CAcroPDDoc
Dim jso As Object
Set gApp = CreateObject("AcroExch.App") ' make acrobat session
Set pdDoc = CreateObject("AcroExch.PDDoc")
If pdDoc.Open("C:\2762deel1-aang-N.c.pdf") Then ' the PDF document we want to fill in open it
If Not jso Is Nothing Then
pdDoc.Save PDSaveIncremental, path ' save changes to the PDF document
pdDoc.Close ' close the PDF document
MsgBox ("Failed could not open PDF ")
Set pdDoc = Nothing ' clear
The "problem" is that this macro will only run on a machine where Acrobat is installed ( Reader or D istiller is not enough )
Open in new window
December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.