You nailed it. I would use less generous language than you did to describe VBA's deficiencies in Mac Excel 2011. Huge parts of what could be considered the stdlib are totally missing in the Mac version. The language doesn't even have native dictionaries.
Backend data connectivity options are virtually non-existant. Excel 2011 has what appears to be a 10+ year old version of MS Query.
Some 3rd party financial plugins are Windows dependent, and I believe some of the Microsoft analysis additions are as well.