Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel Error
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing PDF from Excel Error
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 -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Printing Error | New Users to Excel | |||
Excel 2007 printing error: "The number must be between 10 and 400. | Excel Discussion (Misc queries) | |||
how can i avoid an error message while printing an excel sheet | Excel Discussion (Misc queries) | |||
Error Printing Excel 97 linked to access 97 on NT | Excel Discussion (Misc queries) | |||
Excel 97 printing error. | Excel Programming |