Is there an alternative to Microsoft Scripting Runtime library in Excel VVA for Mac OS X?
I have a workbook with plenty of VBA on it, 开发者_如何学Gomany using the Dictionary
object. The problem is that Excel for Mac OS X doesn't seem to have the "Microsoft Scripting Runtime" library, thus, no Dictionary
object.
How could I solve this issue? Is there any alternative library? Any alternative Dictionary class?
I used Collection instead of Dictionary, and my problem is now solved now is now partially solved, as Collection seems to be native.
UPDATE: The problem is that Dictionary has some more features, like iterating through the keys. But I could work around this in my specific case.
精彩评论