Printing PDF from Excel Error

K

Kim

We have written a macro in excel to print pdf files. However, this
macro seems to only work on one specific computer. All other
computers in the office receives an error message. The error says:

Run-time error '429':
ActiveX component can't create object.

Below (***) is where it errors out at:

Dim AcroExchAVDoc As Object, AcroExchPDDoc As Object, _
AcroExchApp As Object
Dim strFileName As String, strPath As String
Dim iNumberOfPages As Integer, i As Integer

***Set AcroExchApp = CreateObject("AcroExch.App")
Set AcroExchAVDoc = CreateObject("AcroExch.AVDoc")
Set AcroExchPDDoc = CreateObject("AcroExch.PDDoc")

Any help or suggestions is greatly appreciated.
 
K

Kevin

Do you have the same version of Acrobat on all machines?
Also, have you checked references on your machine as well
as the one(s) your having trouble with?

I am not sure if that will help you, but it should give
you a place to start.

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Open, print, close multiple pdf's from macro 2
VBA Export to PDF 0
Word macro that can call cells out of Excel for a find and replace 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Remove Identical words 0
Export specific fields from access to Excel 0

Top