superinstitute.blogg.se - Delete a macro in excel 2011 for mac vba

DELETE A MACRO IN EXCEL 2011 FOR MAC VBA UPDATE

Public KeyValuePairs As Collection ' open access but allows iteration 'plus KeyValuePairs collection, KeyValuePair(Index as long), Tag as variant 'Collection methods: Add, Count, Item, Remove Save this as a plain text file named Dictionary.cls and import into excel VERSION 1.0 CLASS 'Unrestricted class just to hold pairs of values together and permit Dictionary object updating

Save this as a plain text file named KeyValuePair.cls and import into Excel VERSION 1.0 CLASS Patrick O'Beirne sysmod wrote a class set that addresses this issue.īe sure to stop by Patirk's Blog to say thanks! Also there is a chance he has a newer version. Pulling the Answer from the comments to prevent link rot. Write 2 completely separate routines to do the same thing ( please let this not be what needs to happen): isMac = CheckIfMac ' Change dictionary variable to some other data type that is Mac friendly and provides the same functionality

Use a Mac plugin that enables use of Dictionaries on Macs ( my favorite option if one exists)ĭo some kind of variable switch like the following: isMac = CheckIfMac.

The following are the 3 cases I can think of as being possible solutions: My question is, is there a way to make this work on a Mac?

Which is the result of using the Tools > References > Microsoft Scripting Runtime library. I recently had a user attempt to use it on a Mac and received the following error: Compile Error: Can't find project or library I have an Excel VBA project that makes heavy use of Windows Scripting Dictionary objects.

DELETE A MACRO IN EXCEL 2011 FOR MAC VBA UPDATE

Vba loop through dictionary vba dictionary of arrays vba dictionary get item by key vba collection vba dictionary vs collection vba dictionary of dictionaries vba dictionary count vba dictionary update value