topic Re: Error 429 in VBA Forum

Error 429

Anonymous — Tue, 06 Apr 2004 15:47:05 GMT

Firing a macro at open and close of a drawing, on some machines I get an Error code 429. I have a reference to the Microsoft ActiveX 2.7 object library, and the msado15.dll is present on all machines. Trying to setup a begin_close event.
On some machines, I recieve the error "Could not create the ActiveX object(or something to that effect), while others work fine. The code reads as follows:

Public WithEvents ACADApp As AcadApplication

Sub Example_AcadApplication_Events()
Set ACADApp = GetObject(, "AutoCAD.Application")
End Sub
Any ideas on why it doesn't work on all machines? Running Acad 2K4, WinXP. TIA

Re: Error 429

Anonymous — Tue, 06 Apr 2004 18:40:18 GMT

Assuming you are doing this in vba [because you mention macro], here is how you get the running instance: Set ACADApp = AcadApplication Don't use GetObject unless you are working in full VB. Second and most likely problem is the version of ADO. On the ones that error, check the installed version - just because they have msado15.dll doesn't mean its 2.7.

Re: Error 429

Anonymous — Tue, 06 Apr 2004 20:14:00 GMT

Thanks Mike........but I'm a little confused now. They are all linking to a common database, so shouldn't they all require the same references? I'm a little green in the VBA arena, but learning it. I'll change some of the references and see if it helps, but in the meantime, any further enlightment you can offer is greatly appreciated.

Re: Error 429

Anonymous — Tue, 06 Apr 2004 21:25:02 GMT

Okay Mike. I changed it from getobject to acadapplication and that fixed the problem. I'd still like to know why the other way works on some machines, and on some it doesn't. Thanks again.