VBA Code error with Adobe Acrobat 10 Type Library

Forum|Forum|13 years ago
January 29, 2013
4 replies
65359 views

Hi,

I have some code I created in Word VBA to combine several separate PDFs into a single PDF. The code works fine with the Adobe Acrobat 9.0 Type Library and Adobe Reader 9.0 installed.

But, with the Adobe Acrobat 10 Type Library and Adobe Reader 10 installed, the code fails at the marked code below. Any suggestions??

Dim acrobatApp As Acrobat.acroApp

Set acrobatApp = CreateObject("AcroExch.App")

Dim mainPDF As Acrobat.AcroPDDoc

Set mainPDF = CreateObject("AcroExch.PDDoc") ****THIS IS WHERE THE CODE STOPS WITH A "TYPE MISMATCH" ERROR****

Dim nextPage As Acrobat.AcroPDDoc

Set nextPage = CreateObject("AcroExch.PDDoc")

Dim numPages As Integer

'Loop through all selected VLS, and add each one to the end of the main PDF

For i = 0 To lstSelected.ListCount - 1

mainPDF.Open CurDir & "\" & Replace(ThisDocument.Name, ".doc", "") & ".pdf"

numPages = mainPDF.GetNumPages

nextPage.Open lstSelected.List(i)

If mainPDF.InsertPages(numPages - 1, nextPage, 0, nextPage.GetNumPages, True) = False Then

MsgBox "Cannot insert pages"

End If

If mainPDF.Save(PDSaveFull, CurDir & "\" & Replace(ThisDocument.Name, ".doc", "") & ".pdf") = False Then

MsgBox "Cannot save"

End If

'MsgBox lstSelected.List(i)

nextPage.Close

Next i

Acrobat SDK and JavaScript

This topic has been closed for replies.

P

philipr61883589

Participant

I am having the same problem with Windows 10, VBA for Excel and Adobe InDesign CS6 and Illustrator CS6 Type library. Same errors Type mismatch trying to instantiate the application. and then errors setting the document as a child of the app. I lost a $4000 job because of this.

.

Bernd Alheit

Community Expert

You need Adobe Acrobat to combine PDF files.

R

RobertJ_Baker

Participant

I had the same error (429 ActiveX component can't create object) at the same line when trying to create the same object using 10 but not in 9. I then sat down at a computer with Adobe Pro Extended and the code works just fine.

Bernd Alheit

Community Expert

Is Adobe Acrobat installed on the system? Your code will not work with Adobe Reader.