Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Error 429, "Can't create object"
In running a VBA process in Excell2000 to query an Access database, I
get this error on some machines, but not others. In perusing the internet, I have come across various "fixes", but nothing seems specific to Excel, mostly VB5 and VB6. Do I need to do something on my target machines to re-register some dll or ocx? I can post the offending code if you want. Thanks Doc Rock |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Error 429, "Can't create object"
This article may help.
http://support.microsoft.com/default...b;en-us;200271 Alt F11, Tools|References and look for something marked as 'MISSING' also check that an Add In isn't missing. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Doc Rock" wrote: | In running a VBA process in Excell2000 to query an Access database, I | get this error on some machines, but not others. In perusing the | internet, I have come across various "fixes", but nothing seems specific | to Excel, mostly VB5 and VB6. | Do I need to do something on my target machines to re-register some dll | or ocx? | I can post the offending code if you want. | | Thanks | | Doc Rock |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Error 429, "Can't create object"
Thanks, I'll look at it. Does VBA in Excel 2000 equate to VB 6.0?
Dave Patrick wrote: This article may help. http://support.microsoft.com/default...b;en-us;200271 Alt F11, Tools|References and look for something marked as 'MISSING' also check that an Add In isn't missing. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX Error 429, "Can't create object"
That's a pretty general statement but for the most part yes.
-- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "Doc Rock" wrote: | Thanks, I'll look at it. Does VBA in Excel 2000 equate to VB 6.0? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
"Error in loading DLL", VB6 ActiveX DLL | Excel Programming | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
Error 429 can't create activex object - winsock | Excel Programming | |||
error with userform, "unable to create embedded object" | Excel Programming |