ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   429 ActiveX can't create the object (https://www.excelbanter.com/excel-programming/326119-429-activex-cant-create-object.html)

CA

429 ActiveX can't create the object
 
All of the VB code to automate a PDF/Distiller conversion is correct
(Distiller has been referenced in the VB project), but the code after the
dimensioning of PDF distiller - the set statement returns the 429 error
message, I think that I am missing a DLL - but can't figure out which one,
would appreciate your help.

Thanks!

Tom Ogilvy

429 ActiveX can't create the object
 
Probably the 3rd one.

If you think not, maybe you can show the pertinent code.

--
Regards,
Tom Ogilvy

"CA" wrote in message
...
All of the VB code to automate a PDF/Distiller conversion is correct
(Distiller has been referenced in the VB project), but the code after the
dimensioning of PDF distiller - the set statement returns the 429 error
message, I think that I am missing a DLL - but can't figure out which one,
would appreciate your help.

Thanks!




Maury Markowitz

429 ActiveX can't create the object
 
"CA" wrote:

All of the VB code to automate a PDF/Distiller conversion is correct
(Distiller has been referenced in the VB project), but the code after the
dimensioning of PDF distiller - the set statement returns the 429 error
message, I think that I am missing a DLL - but can't figure out which one,
would appreciate your help.


I assume I am missing the start of the thread here... was the code snippet
supplied?

Anyway, welcome to DLL hell. I have recently worked through these sorts of
problems myself. 429, in my experience, means "wrong version" -- specifically
that the API found in the DLL and the API found in the registry are not the
same. Why they don't use more specific error messages I don't know, although
this has been a constant problem I've seen in all of Office.

Suggestion:

1) Uninstall Distiller completely.
2) use regedit to back up your registry
3) use regedit to find anything relating to distiller and deleting it -
examine the keys carefully, sometimes you'll find a reference inside a folder
with a long hex-ish key on it, and the entire folder should be deleted in
these cases.
4) open Excel and make sure it's gone from references
5) re-install distiller, and run it once so it registers
6) try again in excel

I have to carry out these steps every time I compile up a new version of my
VB code, hopefully you won't be having to do this too often.

Maury


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com