开发者

Is there an alternative to Microsoft Scripting Runtime library in Excel VVA for Mac OS X?

开发者 https://www.devze.com 2023-02-07 13:51 出处:网络
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, t

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消