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.
Mac doesn't support Dictionary object.
You need to rewrite the code.
I am not good in macros, Can someone please rewrite this code which can be ran through Mac.
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.
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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
Hello Hello harman83,
Did you try zipping the file before you uploaded it?
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
One of my friend ran the code and he is getting error
Sub or Function not defined
(Module3 1:0)
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
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??
Hello Harman83,
Here is the file.
Note: I downloaded the file and checked for the macro code. It is in the module DecisionRole.
Last edited by Leith Ross; 11-12-2015 at 03:25 AM.
Sounds like easy Find method...
Please Login or Register to view this content.
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.
Hello Harman83,
Second attempt...
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
Following Code is working in Mac now.... Thankyou everyone for helping me out...
Please Login or Register to view this content.
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?
Thanks for your help, I appreciate it! Thanks, RalphPlease Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks