CODEWITHSUNDEEP
excelvbaadobe
CarlosG1
CarlosG1

Reputation: 11

How can I manipulate the "Adobe Acrobat Reader (64-bit)" app within excel using VBA?

I have some experience using VBA, and I am interested in using "Adobe Acrobat 10.0 Type Library" to be able to open the adobe reader app within VBA and manipulate or extract information in adobe acrobat reader pdf files.

my error is attached.

enter image description here

The code below is what I am trying:

Public Sub DoSomething_Adobe()
    Dim AcroApp As CAcroApp
    Set AcroApp = CreateObject("AcroExch.App") 'ERROR IS HERE
    AcroApp.Show
End Sub

I was expecting this code to open the reader and maybe transfer control to the reader.

Upvotes: 0

Views: 480

Answers (1)

CarlosG1
CarlosG1

Reputation: 11

I was able to run this procedure, but only with adobe acrobat pro, which I had to get by getting the adobe creative cloud subscription. It will not work with the adobe acrobat reader, which is the free edition.

Upvotes: 1

Related Questions