+ Reply to Thread
Results 1 to 19 of 19

Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

  1. #1
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Respected Experts,

    I am not able to run the following Macro in Excel in Mac computer. I am getting Runtime Error 429 - ActiveX Component Can't Create Object and it is on code
    Set Dict = CreateObject("Scripting.Dictionary").

    Kindly help me tweak the code as per the Mac capabilities.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,196

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Mac doesn't support Dictionary object.

    You need to rewrite the code.

  3. #3
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    I am not good in macros, Can someone please rewrite this code which can be ran through Mac.

  4. #4
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,192

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    I'm on a Mac. And, therefore not real familiar with the Dictionary object.

    What does that code do?
    It looks like it searches through one range, noting a cell's contents (called the Key) and the contents of the next cell.

    It then looks through a second range, if it finds a cell with the key, it replaces that key with the Offset value.

    Is that what it does? If there are duplicate keys, which matching value is stored, the first or the last?

    Can you attach a sample workbook with a typical before and after?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello harman83,

    The Mac supports the Collection Object. Here is your code re-written using the Collection in lieu of the Dictionary.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  6. #6
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Thanks for the code Leith. I don't have Mac with me,I am using windows currently, Mac is in my office and this can be tested by me tomorrow only, but now If my problem has caught your attention I dont want to loose this opportunity. Can you please help me by testing this for me.

    As as result I want my tab "Copied Sheet" Col L cell values to get yellow in color for all the values which it will see in tab "campaignId".
    Example I want L2 and L3 to display these cells values in yellow color....
    Align Business & IT Goals
    Authorize Purchases

    My file is 1.8MB not able to attach here because of 1MB limitation . Dont know how to test it now...

    Thanks
    Harman

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello Hello harman83,

    Did you try zipping the file before you uploaded it?

  8. #8
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Moses Sheet3.zip
    Here is my sample file. Tab Copied sheet COl L should give values in yellow color with respect to data from tab campaignId

  9. #9
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    One of my friend ran the code and he is getting error

    Sub or Function not defined
    (Module3 1:0)

  10. #10
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello Harman83,

    Here are the results...

    Was..
    IT
    Purchase
    Create IT Strategy
    Needs
    Evaluate
    ITES
    OTES
    Opr

    Now...
    Align Business & IT Goals (Yellow)
    Authorize Purchases (Yellow)
    Create IT Strategy (Yellow)
    Determine IT Needs (Yellow)
    Evaluate/Specify Brands or Vendors (Yellow)
    Align Business & IT Goals (Yellow)
    ITES
    OTES
    Opr

  11. #11
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Yes the results you have shown is absolutely correct. But not sure why my friend is getting this error...
    Sub or Function not defined
    (Module3 1:0)

    Can youplease send me the file with the code??

  12. #12
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello Harman83,

    Here is the file.

    Note: I downloaded the file and checked for the macro code. It is in the module DecisionRole.
    Attached Files Attached Files
    Last edited by Leith Ross; 11-12-2015 at 03:25 AM.

  13. #13
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,196

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Sounds like easy Find method...
    Please Login or Register  to view this content.

  14. #14
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Thanks Leith for your help on this problem...

    The file you sent does not have your macro in it. Kindly resend the file with the code.

  15. #15
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello Harman83,

    Second attempt...
    Attached Files Attached Files

  16. #16
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hi Leith

    The file you sent, does not have your code..In Module Decisionrule..I can see the same code which was not working on Mac because of ActiveXcomponent..
    Runtime Error 429 - ActiveX Component Can't Create Object

    It does have the code which replace Set Dict = CreateObject("Scripting.Dictionary") like this instance completely.

    Thanks
    Harman

  17. #17
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Following Code is working in Mac now.... Thankyou everyone for helping me out...

    Please Login or Register  to view this content.

  18. #18
    Registered User
    Join Date
    11-28-2018
    Location
    Texas
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Dear Leith, I get the same error in a VBA macro I intend to run in Excel (Office 365) on a Mac (Mac OS Mojave). Are there possibly also code elements which aren't supported on the Mac, which I can replace?

    Please Login or Register  to view this content.
    Thanks for your help, I appreciate it! Thanks, Ralph

  19. #19
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Mac throwing error - Runtime Error 429 - ActiveX Component Can't Create Object

    Hello ralphnohe,

    Welcome to the forum!

    As far as I know, CreateObject does not work on the Mac. There may be a work around for your code but not being a Mac expert, I can not say for certain.

    Please be sure to read the forum rules about posting. You broke a couple in this post: posting a question in another post and posting a new question in an old thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime Error 429 - ActiveX Component Can't Create Object
    By bmaster123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2015, 04:37 PM
  2. error 429 ActiveX Component can't create an object - only when scheduled
    By Demsoft in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-06-2015, 05:03 AM
  3. Error 429: ActiveX component can't create object
    By manali7120 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2013, 01:31 PM
  4. Run-time error '429' ActiveX component can't create object
    By gamaz in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-29-2012, 10:24 PM
  5. [SOLVED] Run-time-error '429': ActiveX component can't create object
    By Lloyd Blankfein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-28-2012, 07:21 PM
  6. Run Time error 429 (ActiveX component can't create object)
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2012, 03:08 PM
  7. Run-time error ‘429’ ActiveX component can’t create object
    By AliJay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-14-2012, 05:13 AM

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