Mac Excel error - "Dictionary.cls is not supposed in VBE. The file can't be loaded."

VBA-tools / VBA-Dictionary

Drop-in replacement for Scripting.Dictionary on Mac

MIT License

348 stars 89 forks source link

Mac Excel error - "Dictionary.cls is not supposed in VBE. The file can't be loaded." #12

Closed sayem closed 9 years ago

sayem commented 9 years ago

Hi, I'm new to VBA and I'm trying to load a macro on my Mac Excel that uses Scripting.Dictionary, and I'm trying to use VBA-Dictionary as a replacement for it, but I'm running into some errors.

Importing the Dictionary.cls file throws an error saying that it's not supported in VBE and can't be loaded:

mac - dictionary cls error

And I was trying to put it into a module and run it, but then that throws a compile error:

screen shot 2015-06-04 at 10 10 52 pm

Any idea how I can load VBA-Dictionary? I'm on Excel for Mac 2011 (v14.5.1), would love any help.

timhall commented 9 years ago

Hi @sayem I have seen some line-ending encoding issues with downloading from Github, see this comment for resolution details: https://github.com/VBA-tools/VBA-Dictionary/issues/5#issuecomment-77081615

Let me know if that doesn't work for you.

sayem commented 9 years ago

Yup, simply downloading the entire repo and then importing did the trick. Thanks!