+ Reply to Thread
Results 1 to 5 of 5

Run-time error ‘429’ ActiveX component can’t create object

  1. #1
    Registered User
    Join Date
    06-04-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    53

    Run-time error ‘429’ ActiveX component can’t create object

    Hi guys,

    I have been using an ActiveX worksheet for a couple of years without issue. I have just “upgraded” to Windows 7 and Excel 2010 and now the problems have started. I am slowly working my way through them but I’ve got to one which has me stumped.

    I’ve posted the code below.

    I get error 429 in the following code at the line starting:
    Set objTWSControl = New cTWSControl

    Please Login or Register  to view this content.
    Any help in solving this would be very much appreciated.

    John

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Run-time error ‘429’ ActiveX component can’t create object

    What is cTWSControl? It looks like a custom class. Does it reference anything that isn't available in Windows 7?

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Run-time error ‘429’ ActiveX component can’t create object

    If it's a calendar control then Excel 2010 does not support them. See non-activeX alternatives here, in the DatePicker section
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    06-04-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Run-time error ‘429’ ActiveX component can’t create object

    Thanks Kyle and Roy for your replies. I did not write the software and just installed it and played around with it. cTWSControl does look to be a Custom class that works on XP & Excel 2003 but NOT on W7 & Excel 2010. With my limited knowledge I'm not sure if it's a calendar control.

    The problem actually does seem to be with Windows 7 because I have just installed Excel 2003 on the new machine and I'm getting the same problem.

    Why do MS change their OS so much that software can't work?

    Thanks again for your comments.

    John

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,144

    Re: Run-time error ‘429’ ActiveX component can’t create object

    Can you post the code for the class?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1