Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 134
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Printing Error Jeff New Users to Excel 4 February 19th 08 05:39 PM
Excel 2007 printing error: "The number must be between 10 and 400. Boris Excel Discussion (Misc queries) 1 July 30th 07 08:30 PM
how can i avoid an error message while printing an excel sheet solidad Excel Discussion (Misc queries) 1 August 13th 06 01:00 PM
Error Printing Excel 97 linked to access 97 on NT BenAshdown Excel Discussion (Misc queries) 0 April 27th 05 12:16 PM
Excel 97 printing error. tmphysique Excel Programming 0 August 3rd 04 05:29 AM


All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"