I thought Excel for Mac 2011 was vba-enabled?
Would someone please take a look at my simple code (in module 1) and the attached error message and let me know what I'm doing wrong? It is running fine on Windows but not on Mac OS.
Would there be a way to adapt my code so that it can be ran on a Mac?
Many thanks in advance.
ESL CO windows.xlsm
Screen Shot 2013-04-23 at 7.21.42 PM.png
Screen Shot 2013-04-23 at 7.22.07 PM.jpg
the scripting runtime library does not exist on macs so you can't use it-you would need to create your own class equivalent. searching google for mac vba hashtable will find some possible options for you
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks Joseph. I'm not sure I understand what you mean but I get that my code needs to be modified...
Given that my code is short, would any generous soul be willing to re-write it so that it would work on both Mac and Windows platforms?
Thanks.
your code will not be short once rewritten since you will require a class to replace the dictionary object. if you search as I suggested you should find ready made code replacements
Would there be a way to circumvent the "dictionary" approach used in the current code with an equivalent procedure which Mac could handle? This code was written by someone else so I'm not familiar with "how" it works.
I will try and have a look at it this evening
I've added a Hashtable class which should work in windows and mac versions and altered your code to use it
Amazing. Seems to work fine in Windows. I will test on my Mac tonight and let you know.
Thank you so much for your help Joseph.
Olivier
Works like a charm on Mac too. Thanks so much Joseph.
you're welcome :-)
How can I mark as solved?
use the 'thread tools' link at the top of the page
Not working. I only have: show printable, email to a friend, unsubscribe, add a poll...
oh-I think too much time has passed and you need to ask a moderator to do it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks